| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Zeros
I have a spreadsheet with currency values in cells D16-
H50. Column H is the last column in the spreadsheet. How can I automatically have all the cells with a 0 in it change to the dash(-) when it's is opened? I Really need the code because I suck at excel. Thanks in advance. OS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting zeros as dashes | Excel Discussion (Misc queries) | |||
| when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
| Conditional formatting to ignore zeros | Excel Worksheet Functions | |||
| Formula/formatting to omit trailing zeros | Excel Worksheet Functions | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
