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


--
mkaye
------------------------------------------------------------------------
mkaye's Profile: http://www.excelforum.com/member.php...o&userid=31229
View this thread: http://www.excelforum.com/showthread...hreadid=508984