Are your numbers really numbers or are they text that look like numbers? I
ask because we need to know what is in the cell when the number has leading
zeroes like this.... 00123456.

Rick


"Jac" wrote in message
...
I have a set of numbers, ex: 43441900 However, I only want to keep the 4
numbers in the middle (4419). How do I delete the 1st set of numbers (43)
and the last set of numbers (00)? I need to copy this format in over 1000
rows.

I need help quickly. I have to present a report to my boss as soon as
possible.

Version...Excel 2003
Thanks