Combining values from seperate cells

[Ionisation]

If I have a number eg 125431254. I want to add a '0' at the front of this making it 0125431254. I want to do this to over 1000 numbers. Exactly the same thing, adding a '0' at the beginning of each number. Is there a function or formulae to help me do this quickly?

Ionisation from London

 

[patrickmuldoon99]

You can format the adjacent cell as text and use

presuming number is in col A:

="0" & A1

Then drag down to get the new string for each number.

Alternatively, you could not format the cell as text, and use

="'0" & A1


Whereabouts in London are you?

HTH

Patrick

 

[Ionisation]

Cheers Patrick!! This is the first time I've used this website and this message board ofcourse. This prompt and useful response makes a great first impression!!

Duvall