=Text

[Bob]

I have a long column of ref numbers, each cell needs to be converted
to text. So i am using =TEXT (B2,0) - (with the result I then copy
and paste as special)

This works fine .... up to a point. As I also need the ref number to
have 8 digits so a number that starts as 6 digits needs to be padded
with two zeros at the start ie 585859 needs to end up as 00585859.

Can this adjustment be made in the original =TEXT statement, if so how
or what is the best way to deal with this problem.

With thanks

 

[Lars-Åke Aspelin]

I have a long column of ref numbers, each cell needs to be converted
to text. So i am using =TEXT (B2,0) - (with the result I then copy
and paste as special)

This works fine .... up to a point. As I also need the ref number to
have 8 digits so a number that starts as 6 digits needs to be padded
with two zeros at the start ie 585859 needs to end up as 00585859.

Can this adjustment be made in the original =TEXT statement, if so how
or what is the best way to deal with this problem.

With thanks

Try this:

=TEXT(B2,"00000000")

Hope this helps / Lars-Åke

 

[Bob]

Try:

=TEXT (B2,Rept(0,8))

--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)

Thanks NBVC exactly waht I was after.

Bob