| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does excel convert my text "6990011011234" to "6.99E+12"?
Why does excel convert my text for example "6990011011234" to "6.99E+12"?
I am runing a "import to excell" from a web site. When imported, the identification # is changed to #.###E+##. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does excel convert my text "6990011011234" to "6.99E+12"?
Excel doesn't know it's text.
Either put an apostrophe in front of it: '6990011011234 or change the number format of the cell: FormatCellsNumber tab Category: Text Does that help? *********** Regards, Ron XL2002, WinXP-Pro "pj" wrote: Why does excel convert my text for example "6990011011234" to "6.99E+12"? I am runing a "import to excell" from a web site. When imported, the identification # is changed to #.###E+##. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Linear Mode
