Select your data, then right click the highlighted selection, select Format
Cells, select number, then choose which decimal place you want. Hope this
helps! If so, let me know, click "YES" below.

--
Cheers,
Ryan


"BABs" wrote:

This works but changes everything to scientific format or rounds off to the
nearest thousand. Can't figure out how to keep the hundreds, tens and ones.
????



"Ryan H" wrote:

There is a very easy way without using code. I will assume you are using
Excel 2007. Just highlight the column with the hyphenated numbers, click the
Find & Select button in the Home tab on the Ribbon, click Replace, in the
Find What field type -, and leave the Replace With field empty, then click
the Replace All button. That should do it for you.

Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan


"BABs" wrote:

I have a column that has hyphenated numbers (XX-XX-XX-XXX-XXXX) and I need to
get rid of the hyphens. They are all in the same format so I think if I
could write code to del the 3rd, 6th, 9th, etc characters from a cell, it
would work. I just can't seem to figure the code out. or is there an easier
way?
Thx.