1

I have some cells that are formatted as hours and minutes i.e. [h]:mm.

If no value exists in a cell I want the cell to show 0:00 without having to manually type.

It needs to be user friendly, so if I copy cells from another spreadsheet and there are no values the 0:00 should not become blank.

Improve this question
1
  • You can make it for cells where you have a value of 0. But I think you cannot do it for cells which are blank, i.e. no value at all.
    – ZygD
    Mar 28, 2015 at 19:47

1 Answer 1

Reset to default
0

Try using Find and Replace:

Ctrl+F to bring up the Find and Replace box Leave "Find what:" blank Click on the replace tab and type 0:00 in the "Replace with:" box Click Replace all

If you want this applied to only a certain column, hihglight the column before replacing all

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .