How do i keep cells blank until the formula is used?
Hello PB
On this subject, I have the 'Zero Values' unchecked, but would like to also
hide the dashes (-) a zero balance still displays. Can I do this?
Thanks
Roger
"Pancake Batter" wrote in message
...
Hi Ellen
Menu Bar, Tools, Options, View Tab. Unckeck box "Zero Values".
PB
"Ellen" wrote:
I am working on a timesheet that add time and calculates cost. The
formula I
am using for column I of the timesheet (which can be used for up to three
in/out times per day) is "=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)".
Column J calculates cost using the formula "=I12*B12" where column B is
the
hourly fee.
My question is, how can I get columns I and J to be blank until they are
needed. Right now they fill with "0.00" and "$0.00."
|