| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I hide zero values but keep currency format in P.O. form?
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only if there is a value in the Quantity and Unit Price section. I formatted the Total cells to Currency. But if there are no values in Quantity or Unit Price, zero values appear in the Total cells. How do I format the total cells to only show price values when there are values in Quantity and Unit Price? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I hide 0 values in line charts | Charts and Charting in Excel | |||
| format cells for currency 2450 and have it format to $24.50? | Excel Worksheet Functions | |||
| format column for unique values only | Excel Worksheet Functions | |||
| CONVERT DATA TO CURRENCY FORMAT | Excel Discussion (Misc queries) | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
Threaded Mode
