| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide 0.00 on spreadsheet with formula?
Highlight the column(s) and go to Format/Cells and on the 'number' tab and
choose custom - change the type to: #;; "Tammy4" wrote: I am using Excel 2003. I am doing a spreadsheet for commissions for sales reps. Is there a way to not display 0.00 in every cell in a column of the spreadsheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide row on spreadsheet | Excel Discussion (Misc queries) | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| How do you hide unused cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I hide a formula so it will not show on the spreadsheet? | Excel Worksheet Functions | |||
| how do you hide the #DIV/0! in a blank spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
