SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-278542%22%20slang%3D%22en-US%22%3EI%20want%20to%20add%2000'%20before%20the%20contents%20of%20a%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278542%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20which%20has%20content%20in%20the%20format%2025'42%20(represents%20time)%20which%20I%20want%20to%20convert%20to%2000'25'42.%26nbsp%3B%20What%20is%20the%20quickest%20way%20to%20amend%20the%20entire%20column%3F%26nbsp%3B%20Not%20conversant%20with%20macros.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281388%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20I%20want%20to%20add%2000'%20before%20the%20contents%20of%20a%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281388%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20thanks.%20Got%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278705%22%20slang%3D%22en-US%22%3ERE%3A%20I%20want%20to%20add%2000'%20before%20the%20contents%20of%20a%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278705%22%20slang%3D%22en-US%22%3EHow%20about%3A%20%3D%2200'%22%26amp%3BA1%20Or%20type%20the%20format%20you%20want%20in%20the%20first%20cell%2C%20then%20go%20to%20Data%20%26gt%3B%20Flash%20Fill.%3C%2FLINGO-BODY%3E
Highlighted
Anthony Stroude
New Contributor

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 Replies
Highlighted
How about: ="00'"&A1 Or type the format you want in the first cell, then go to Data > Flash Fill.
Highlighted
Solution

Great thanks. Got it.