Thursday, January 14, 2016

yogi_Use Custom Number Format To Display Results That Amount To 0 (or $0.00) As Blanks

Google Spreadsheet   Post  #2019
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-14-2016
post by: Lampasas Trucking:!topic/docs/NAp-GMNpIgs;context-place=forum/docs
Getting rid of the "$0.00" until I input an amount

I'm attempting to make invoices for my business, which is cement and crane work. There are times when I do not know the amount of hours the crane will be running, therefore I cannot input the amount due. The guys go out and do all the heavy labor, and prior to them leaving, I must have an invoice for them to go off of. When I do not enter a number of hours, it simply stays at $0.00, which is correct, but then when the customer signs the invoice at the end of the job, lets say it was a 6 hour crane job, the new total of $1065.00 has to be scribbled (handwritten) over the old $0.00. It just looks unprofessional and is annoying. I don't want to delete the formula, because I'm aware that would rid me of the "$0.00". Any help would be appreciated!! Thank you!