Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |