| Home |
| Search |
| Today's Posts |
|
#3
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 |
| 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 | |||
Threaded Mode
