missing zero

[infinitelo]

Problem: I wrote a nice little foxpro program to output to an html file. It created a nice neat simple table. What has happend is that a user discoverd that xcel 2000 can open the html file and she can insert values. okay fine. but one of the columns has a significant leading zero and xcel removes it. Is there syntax in html to prevent the loss?

note: xcel converts the file to a more complicated format have not tried various browers on the new file(netscape,ie4,ect...)

... dont try this at home it could explode.

 

[dgrewe]

The only thing I can think of is to configure Excel to read that column as a string and not a number.

Now for the tricky part, Now to do it - I do not have a clue. Why, because of this thing called a user. You can make a spreadsheet to import the data into and format the column correctly, but what saids the USER will do it every time.

Good Luck on this one.
David W. Grewe
Dave@internationalbid.com

 

[infinitelo]

thanks for the quick respond