| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Reverse Contents in an Excel cell (Text or a Number) | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
