[SOLVED] Format cell: Keeping my fomula cells blank?

gimmickless · Last edited by gimmickless on Sun Apr 11, 2010 11:16 am; edited 1 time in total

I'm editing a quote sheet for a contractor, and want to minimise any and all typing I do. Here's a partial screenshot.

As you can see, G7=C7*D7. I haven't figured out how to format the cell so that if there is no data, nothing is displayed. "." is close, but " " does not work (nothing is ever displayed). Will I need to continue using "." as a near-fix, or is there another method I should use?

* EDIT: Screenshot too large. Resized for most browsers.

thomasjk · Super User Joined: 16 Dec 2005 Posts: 2308

Tools---Options--->Openoffice.org Calc--->View Uncheck "Display zero values".

gimmickless · Posted: Sun Apr 11, 2010 11:15 am Post subject:

Thanks, I didn't see that earlier. Is there an equivalent for this in MS Office?

thomasjk · Super User Joined: 16 Dec 2005 Posts: 2308

I don't know. I haven't used MS Office for years.

keme · Posted: Sun Apr 11, 2010 12:02 pm Post subject:

Format code # (one single hash character) should work in both applications.