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