Inserting numbers in front of existing numberfs

[kikik]

I have list of numbers and need to insert 00 in front of each. ex 715360850 needs to be 00715360850

Thanks

 

[Domski]

Only post a question once, it gets on the moderators nerves if post more than once and doesn't endear you to them.

You can do it like this:

="00"&A1

Assuming the original number is in A1.

 

[kikik]

Thanks for the quick reply.
sorry hit the submit more than once