Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
General number format
When I format my cells to general number format, some cells show a "0" and
some are blank. How do make them all blank? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
General number format
Clear the contents of those cells????
What do you have in the cells that show 0? What do you have in the cells that look empty? Do you have to use a General format? Maybe you can use a custom number format of: General;-General; dudesicle wrote: When I format my cells to general number format, some cells show a "0" and some are blank. How do make them all blank? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
General number format
toos\options\view\Zero just tick off "ˆš" before "zero value"
€œdudesicle€ç¼–写: When I format my cells to general number format, some cells show a "0" and some are blank. How do make them all blank? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Number format for Combobox | Excel Discussion (Misc queries) | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |