Hi Jim,
Good, that takes off the pressure of guessing whether you had text or numbers for data.
Had they been text cells you would have to do something to remove
the $ sign, and the comma such as using Ctrl+H
Then you would want to include your desired number formatting
but no change in formatting would not occur until text data is converted to numbers.
To TRIM the cells and reenter the values you could use the TrimALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Jim Thomlinson" wrote...
I stand corrected... Cool...