| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display numbers of 12 digits or more?
tried that before posting. It still takes any number over 12 and changes it
to zero. "jlclyde" wrote: On Nov 20, 10:45 am, Jaxboo wrote: Excel keeps taking any digit over 11 and displays them as zero's, Is there anyway to prevent this? I have tried custom formats to no avail. Go to Custom formats and type # for as many numbers as you want displayed. Jay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I display numbers of 12 digits or more?
jaxboo,
I am not sure what you are saying. is it a decimal or just a 12 digit number? If it is a 12 digit number do as I said. If it is a 12 digits after a decimal, start off the custom formatting with a decimal. Is teh column wide enought to support this many digits? Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adjusting display on Y axis to leave out some digits values. | Charts and Charting in Excel | |||
| How do I enter a SSN but only display the last four digits? | Excel Discussion (Misc queries) | |||
| How do I keep Excel from dropping my numbers to 0 after 15 digits | Setting up and Configuration of Excel | |||
| Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
| counting digits, not numbers | Excel Worksheet Functions | |||
Hybrid Mode
