CONVERT NOs TO EAN 8 BY ADDING LEADING ZEROS

[pdb]

I need to convert a row of No's (eg 123) to ean 8 format (00000123)
Any ideas

 

[FSt1]

hi
assuming the numbers are in column A..something like this might work....
in a blank column off to the left....
="00000" & A2
copy(drag) down as far as needed.
you can then copy the helper column and paste special value over the
original data.
or archive it just in case.

regards
FSt1

 

[Paul]

Use custom formatting for the cells

Fomat>Cell then choose Custom in the Category list and in the Type
textbox put 00000000 (8-zeros) then click OK.

Paul

 

[David Biddulph]

=TEXT(A1,"00000000")

 

[Bernd P]

Hello,

David's one would be my preferred one but here's just another example:
=RIGHT(REPT(" ",8)&A1,8)

Regards,
Bernd

 

[David Biddulph]

Did you mean that, Bernd, or did you intend to say =RIGHT(REPT(0,8)&A1,8) ?

 

[Bernd P]

Hi David,

Neither, I meant
=RIGHT(REPT("0",8)&A1,8)

But thanks, of course you saw that

Regards,
Bernd

PS: Would it really work your way? REPT(0,8)?

 

[David Biddulph]

Yes, it would.