I want to add 00' before the contents of a number of cells

[Anthony Stroude]

I have a column which has content in the format 25'42 (represents time) which I want to convert to 00'25'42.  What is the quickest way to amend the entire column?  Not conversant with macros.

[#2]

How about: ="00'"&A1 Or type the format you want in the first cell, then go to Data > Flash Fill.

[#3 · Accepted solution]

Great thanks. Got it.