With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, January 14, 2016
yogi_Use Custom Number Format To Display Results That Amount To 0 (or $0.00) As Blanks
https://productforums.google.com/forum/#!topic/docs/NAp-GMNpIgs;context-place=forum/docs Getting rid of the "$0.00" until I input an amount Hello,
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!