Posted to microsoft.public.excel.misc

pdb

external usenet poster

Posts: 1

CONVERT NOs TO EAN 8 BY ADDING LEADING ZEROS

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to convert numbers and delete leading zeros	Lori	Excel Discussion (Misc queries)	18	January 12th 08 12:45 AM
Leading zeros won't convert to csv file in Excel ver 6 SP2	Pedro	Excel Discussion (Misc queries)	2	September 2nd 06 01:30 AM
save text field w/ leading zeros in .csv format & not lose zeros?	Ques	Excel Discussion (Misc queries)	1	May 4th 05 06:21 PM
Leading zeros	JC	Excel Discussion (Misc queries)	9	February 1st 05 02:33 PM
Adding Leading Zeros to Text	Jenn	Excel Discussion (Misc queries)	4	January 12th 05 06:51 PM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"