I tried this thank you, but because my information is for example KF100-01
and the ones i want to change are KF1-01 to read KF001-01 when i put the find
item it gives me all the items that start with KF1 (including the KF100-01
and it ads the 0 before the 100-01 so it reads kf0100-01 not the way i need
it to read. the cd are supposed to be numbered KF001-01-02-03 etc.
KF002-01-02-03 etc. not KF2-01 KF3-01 get the picture? i really appreciate
your help on this thank you very much it would make my life a lot
easier...thanks again


"Ms. J" wrote:

If "K" only appears in position one, you can
select your column
edit
find
replace

then for "find" you type K
and for "replace" you type K0

then replace all

If you don't highlight the column it will add a zero after every K in your
whole spreadsheet.


"rosygucci" wrote:

I have to add a 0 in some of the numbers that are on the third column example
K10-01 should read K010-01 so that when i put them in order by number thay
will fall in the right order. is there an easy way to do this or do i have to
go change them one by one? remember these are cd's so i have to keep each
line together all columns must correspond. please help. thank you
rosy