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

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


"pdb" wrote:

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

Use custom formatting for the cells

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

Paul


"pdb" wrote in message
...
I need to convert a row of No's (eg 123) to ean 8 format (00000123)
Any ideas

=TEXT(A1,"00000000")
--
David Biddulph

"pdb" wrote in message
...
I need to convert a row of No's (eg 123) to ean 8 format (00000123)
Any ideas

Hello,

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

Regards,
Bernd

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

Bernd P wrote:
Hello,

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

Regards,
Bernd

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)?

Yes, it would.
--
David Biddulph

Bernd P wrote:
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)?