keep cell as text, not number
 

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

keep cell as text, not number
 

Hi

You could format the column as text before you start.

Hope this helps.
Andy.

"mkaye" wrote in
message ...

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

keep cell as text, not number
 

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.

"mkaye" wrote in
message ...

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



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