keep cell as text, not number

[mkaye]

I have a simple spreadsheet that i create from PHP.
I have a column that contains an account # that is 16 digits long. I
output a "'" on the end to stop excel from interpreting this as a
number (the scientific notation only keeps 15 digits so i lose the last
one).
Even if format the column as text & then remove the "'", excel converts
it back to scientific notation.
How can i keep this column as text & keep all 16 digits?

mark

 

[Guest]

Hi

You could format the column as text before you start.

Hope this helps.
Andy.

 

[mkaye]

i can't - i am creating the xls data from a web page and just create
the data & stream it to my local PC - excel interprets the cell as
numeric when i open the file

mark

Hi

You could format the column as text before you start.

Hope this helps.
Andy.