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

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

hi,
this might work for you...
=MID(C4,1,1) & "0" & MID(C4,2,5)
change to fit your data.
look up the mid function in help.
put the formula in a helper column to add the zero. you can then copy the
formula and pastespecial values in the c column to get hard numgers.

regards
FSt1

"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

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

thank you for your reply , but i can't understand what to do...sorry


"FSt1" wrote:

hi,
this might work for you...
=MID(C4,1,1) & "0" & MID(C4,2,5)
change to fit your data.
look up the mid function in help.
put the formula in a helper column to add the zero. you can then copy the
formula and pastespecial values in the c column to get hard numgers.

regards
FSt1

"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