| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers turning to Zero's
Hello,
I am trying to place a large number (19 digits), into a cell, I do this, but when I leave the cell the last four digits turn to zero's. Why? Can anyone help, please. When i go into format cell's the General shows the number in the following format (*.*****E+13), this dosen't look right either, is it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers turning to Zero's
See answer in public.misc and please don't multipost.
Andy. "DaveG" wrote in message ... Hello, I am trying to place a large number (19 digits), into a cell, I do this, but when I leave the cell the last four digits turn to zero's. Why? Can anyone help, please. When i go into format cell's the General shows the number in the following format (*.*****E+13), this dosen't look right either, is it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create leading zeros on variable length numbers | Excel Discussion (Misc queries) | |||
| converting numbers to text | New Users to Excel | |||
| Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
| csv file drops zeros at beginning of a set of Numbers | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Linear Mode
