| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cells help
I have certain cells that may contain a value like: 0.000001
These cells show a zero in their cells. I have other values in the sheet formatted like: "#,##0;(#,##0)" Using a NUMBER FORMAT or modifying the above format, applied to the sheet, can I make these cells show blank rather than zeros? If so, how? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format cells help
Tools options View Tab - uncheck Zero Values
-- jb "xp" wrote: I have certain cells that may contain a value like: 0.000001 These cells show a zero in their cells. I have other values in the sheet formatted like: "#,##0;(#,##0)" Using a NUMBER FORMAT or modifying the above format, applied to the sheet, can I make these cells show blank rather than zeros? If so, how? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format cells help
This doesn't work since the cell contains a value.
"john" wrote: Tools options View Tab - uncheck Zero Values -- jb "xp" wrote: I have certain cells that may contain a value like: 0.000001 These cells show a zero in their cells. I have other values in the sheet formatted like: "#,##0;(#,##0)" Using a NUMBER FORMAT or modifying the above format, applied to the sheet, can I make these cells show blank rather than zeros? If so, how? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 format cells to date format | Excel Discussion (Misc queries) | |||
| How do I format cells to show date in Australian not US format? | Excel Worksheet Functions | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Linear Mode
