Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing 18 digits or more in a cell
Using Excel 2000 and would like to format a cell to show at least 18 digits
with no decimals. I have tried all format possibilities and they all seem to not show all the digits, abbreviate the number or round off the digits over 15. How do I format to show all the digits |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing 18 digits or more in a cell
Format the cell as text *before* you type the data in, or precede the data
by an apostrophe. For numbers, Excel works only to 15 significant figures, so for 18 digits you need text. Once Excel treats the data as a number, you can't regain the lost data by formatting, so you need to get Excel to treat it as text when you first put the data in. -- David Biddulph "Berol" wrote in message ... Using Excel 2000 and would like to format a cell to show at least 18 digits with no decimals. I have tried all format possibilities and they all seem to not show all the digits, abbreviate the number or round off the digits over 15. How do I format to show all the digits |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing 18 digits or more in a cell
Preformat cell as TEXT
"Berol" wrote: Using Excel 2000 and would like to format a cell to show at least 18 digits with no decimals. I have tried all format possibilities and they all seem to not show all the digits, abbreviate the number or round off the digits over 15. How do I format to show all the digits |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering digits in a cell with numbers already inside cell | Excel Worksheet Functions | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
19 Digits in a Cell | Excel Discussion (Misc queries) | |||
12 or more digits in a cell | New Users to Excel |