| 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 |
| 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 | |||
Threaded Mode
