software

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 quot;'quot; 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 amp; then remove the quot;'quot;, excel converts
it back to scientific notation.
How can i keep this column as text amp; keep all 16 digits?

mark--
mkaye
------------------------------------------------------------------------
mkaye's Profile: www.excelforum.com/member.php...oamp;userid=31229
View this thread: www.excelforum.com/showthread...hreadid=508984Hi

You could format the column as text before you start.

Hope this helps.
Andy.

quot;mkayequot; gt; wrote in
message ...
gt;
gt; I have a simple spreadsheet that i create from PHP.
gt; I have a column that contains an account # that is 16 digits long. I
gt; output a quot;'quot; on the end to stop excel from interpreting this as a
gt; number (the scientific notation only keeps 15 digits so i lose the last
gt; one).
gt; Even if format the column as text amp; then remove the quot;'quot;, excel converts
gt; it back to scientific notation.
gt; How can i keep this column as text amp; keep all 16 digits?
gt;
gt; mark
gt;
gt;
gt; --
gt; mkaye
gt; ------------------------------------------------------------------------
gt; mkaye's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31229
gt; View this thread: www.excelforum.com/showthread...hreadid=508984
gt;

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

mark

gt; Hi
gt;
gt; You could format the column as text before you start.
gt;
gt; Hope this helps.
gt; Andy.
gt;
gt; quot;mkayequot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; I have a simple spreadsheet that i create from PHP.
gt; gt; I have a column that contains an account # that is 16 digits long. I
gt; gt; output a quot;'quot; on the end to stop excel from interpreting this as a
gt; gt; number (the scientific notation only keeps 15 digits so i lose the
gt; last
gt; gt; one).
gt; gt; Even if format the column as text amp; then remove the quot;'quot;, excel
gt; converts
gt; gt; it back to scientific notation.
gt; gt; How can i keep this column as text amp; keep all 16 digits?
gt; gt;
gt; gt; mark
gt; gt;
gt; gt;
gt; gt; --
gt; gt; mkaye
gt; gt; -----------------------------------------------------------------
gt;
gt;
gt; -------
gt; gt; mkaye's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31229
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=508984
gt; gt;--
mkaye
------------------------------------------------------------------------
mkaye's Profile: www.excelforum.com/member.php...oamp;userid=31229
View this thread: www.excelforum.com/showthread...hreadid=508984