How do you add a leading zero in front of a colon in Microsoft Excel 2002 example the data imports as 04 and you want it to be 0 04?

Answer 1

You have to treat it as text and concatenate it, which basically means add text to text. You use the concatenation operator, which is the & symbol.

If your 04 was in cell A1 you would use the following formula in the cell you want to have the new value in:

="0 "&A1

That will put 0 04 in the new cell.