Quick formatting question

[Kentetsu]

Hi,

So, in cell B2 I have the number 13. This is a calculated field, so that actual content of the cell is a Sum formula.

All I need is for that 13 to appear as 0:13. I've tried everything I can think of but nothing comes out right. Doesn't seem like it should be this hard.

Thanks for the assistance...

 

[Tetra201]

Try formatting cell B2 as \0\:0

 

[Rick Rothstein]

Alternately, if the 13 won't be used in numerical calculation elsewhere in your workbook is to simply concatenate "0:" onto the front of your SUM formula...

="0:"&SUM(...)

 

[Kentetsu]

Thanks guys. Interesting solution Rick Rothstein, I'll definitely have to remember that one.

In the end, I went with Tetra201's solution because these numbers will later be used in calculations.

Thanks again!

 

[Tetra201]

Glad to have helped.