| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numeric Format Changes From 1 Cell to the Next?
I have a client with a list of numbers, all 15 digits long, in one column.
All cells are formatted as numeric "General". All cells display all 15 digits, except one. This one cell displays the number in scientific notation, even though the cell appears to be formatted as numeric "General". All numbers have a leading zero, which is displayed in all cells, except this one cell. An example of the data is as follows: What was Entered What is being Displayed 020801400000000 020801400000000 020801400880000 2.08014E+13 We are using Excel 2000. Can anyone explain why this is happening and what to do to correct it? All help is greatly appreciated. -- LPS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numeric Format Changes From 1 Cell to the Next?
Excel will display the leading zero(s) only when treating the entry as text.
The cell that is shown in scientific notation is seen by Excel as a number. Your best bet is proobably to explicitly format ALL the cells as Text, then re-enter the one that is being displayed in scientific notation; otherwise you'll evenutally lose the leading zero(s). "LPS" wrote: I have a client with a list of numbers, all 15 digits long, in one column. All cells are formatted as numeric "General". All cells display all 15 digits, except one. This one cell displays the number in scientific notation, even though the cell appears to be formatted as numeric "General". All numbers have a leading zero, which is displayed in all cells, except this one cell. An example of the data is as follows: What was Entered What is being Displayed 020801400000000 020801400000000 020801400880000 2.08014E+13 We are using Excel 2000. Can anyone explain why this is happening and what to do to correct it? All help is greatly appreciated. -- LPS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numeric Format Changes From 1 Cell to the Next?
Thank you. That is exactly what the problem was.
-- LPS "Duke Carey" wrote: Excel will display the leading zero(s) only when treating the entry as text. The cell that is shown in scientific notation is seen by Excel as a number. Your best bet is proobably to explicitly format ALL the cells as Text, then re-enter the one that is being displayed in scientific notation; otherwise you'll evenutally lose the leading zero(s). "LPS" wrote: I have a client with a list of numbers, all 15 digits long, in one column. All cells are formatted as numeric "General". All cells display all 15 digits, except one. This one cell displays the number in scientific notation, even though the cell appears to be formatted as numeric "General". All numbers have a leading zero, which is displayed in all cells, except this one cell. An example of the data is as follows: What was Entered What is being Displayed 020801400000000 020801400000000 020801400880000 2.08014E+13 We are using Excel 2000. Can anyone explain why this is happening and what to do to correct it? All help is greatly appreciated. -- LPS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format cell into Thousands based for numeric data??? | Excel Discussion (Misc queries) | |||
| convert a numeric number in text format in another cell? | Excel Worksheet Functions | |||
| Format cell conditional numeric and text | Excel Discussion (Misc queries) | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Linear Mode
