Am I able to replace 0.00 with blank cell until data input.

[ghrek]

I have cells that have a formula/ sum or a copy and paste special link in it but when I paste special it shows them as 0.00 and looks untidy.

Im trying to get it so the cells are blank until I put data in. Ive tried to do find and replace 0.00 with blank but not having it.

Thanks

 

[rollis13]

You could use Conditional Formatting to apply white color font to hide the contents of the cell when it is 0 (zero) ex. use formula =A1=0

 

[rollis13]

Glad having been able to help .