Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting: display blank when "O", 2 decimal when a number is d
I want to display a blank whenever there is a "O" and I need to display 2
decimal when there is a number. so far I found 0;-O;;@ this formula helps me display a blank cell when needed, however it doesn't give me the 2 decimal I need. Thanks E |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting: display blank when "O", 2 decimal when a number is d
One way
0.00;-0.00; assuming you mean zero and not the letter O, you can't format for letters -- Regards, Peo Sjoblom "ED" wrote in message ... I want to display a blank whenever there is a "O" and I need to display 2 decimal when there is a number. so far I found 0;-O;;@ this formula helps me display a blank cell when needed, however it doesn't give me the 2 decimal I need. Thanks E |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting: display blank when "O", 2 decimal when a number is d
thanks so much
"ED" wrote: I want to display a blank whenever there is a "O" and I need to display 2 decimal when there is a number. so far I found 0;-O;;@ this formula helps me display a blank cell when needed, however it doesn't give me the 2 decimal I need. Thanks E |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Using conditional formatting to "blank" cells | Excel Discussion (Misc queries) | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |