Posted to microsoft.public.excel.misc

Don't want $0.00 to show on invoice is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dollar Sign	merleinkal	Excel Discussion (Misc queries)	1	February 6th 06 05:24 AM
XL invoice replace the dollar sign with euro sign	Pamela casares	New Users to Excel	2	December 16th 05 08:21 PM
Dollar sign	Ralphael1	New Users to Excel	6	October 7th 05 11:45 PM
dollar sign	Jules	Excel Discussion (Misc queries)	3	June 14th 05 09:49 AM
save text field w/ leading zeros in .csv format & not lose zeros?	Ques	Excel Discussion (Misc queries)	1	May 4th 05 06:21 PM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us