Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want dollar sign with zeros in unfilled currenty field?
I am creating an invoice (not using a template). I don't want the unused
currency fields to display zeros / dollar sign. $0.00. How do I leave the unused currency fields blank so that the $0.00 is not showing until a dollar amount is entered in a given line? Thanks, Connie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want dollar sign with zeros in unfilled currenty field?
If you are getting the currency field from somewhere else, then you
can have a formula like: =IF(A1=0,"",A1) where A1 is the cell that holds your dollar amount. Hope this helps. Pete On May 4, 11:30 pm, Don't want $0.00 to show on invoice <Don't want $0.00 to show on wrote: I am creating an invoice (not using a template). I don't want the unused currency fields to display zeros / dollar sign. $0.00. How do I leave the unused currency fields blank so that the $0.00 is not showing until a dollar amount is entered in a given line? Thanks, Connie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want dollar sign with zeros in unfilled currenty field?
Perhaps a Custom Number Format
Select the range of cells to be impacted From the Excel main menu: <format<cells<number tab Category: Custom Type: $#,##0.00_);($#,##0.00);"" Click [OK] Using that, postive and negative numbers will display as currency, but zeros won't display at all (they'll still be there though) Does that help? *********** Regards, Ron XL2002, WinXP "Don't want $0.00 to show on invoice" wrote: I am creating an invoice (not using a template). I don't want the unused currency fields to display zeros / dollar sign. $0.00. How do I leave the unused currency fields blank so that the $0.00 is not showing until a dollar amount is entered in a given line? Thanks, Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dollar Sign | Excel Discussion (Misc queries) | |||
XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
Dollar sign | New Users to Excel | |||
dollar sign | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |