Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display numbers of 12 digits or more?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display numbers of 12 digits or more?
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 |
#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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display numbers of 12 digits or more?
On Tue, 20 Nov 2007 08:45:02 -0800, 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. Here you write, "over 11"; in another post you write "over 12" Is it, perhaps, over 15? If so, then you will need to enter the number as TEXT by either formatting the cell as TEXT BEFORE entering the value, or by preceding the entry with a single quote. --ron |
#5
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 |