Inserting 00 in front of a number 1

[Terridian]

Hi,

I have a list of country codes which are formatted as text cells. What I need to do is insert "00" in front of these numbers so I can then import the final number into a database.

Example: Current number = 91. Required number = 0091.

Is it possible to do this? If so, how?

Thanks in advance

Alex

 

[petrosky]

Hi there,

If 91 was in cell A1, you could put this in A2

="00"&A1

HTH,

Peter

Remember- It's nice to be important,
but it's important to be nice

 

[Terridian]

Excellent! Thanks a bunch.

Alex

 

[KenWright]

Just in case any of your country codes are different to a 2 digit format, and as long as your country codes are numerical you can use the following to give you 4 digit no matter what:-

=TEXT(A1,"0000")

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[shetlandbob]

You could also select the column, goto format cells, select custom and enter 00##

This would change the format of your codes and put a 00 in front.

Robert Cumming

http://www.consultantengineer.co.uk

 

[KenWright]

Downside to that being that the OP said the data is for importing into a database, so just formatting it won't necessarily give you what you need.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[shetlandbob]

ah, ok - i dont work with databases so missed the link there!

Robert Cumming

http://www.consultantengineer.co.uk