Sorry,
I thought you just had a format/display problem and had solved it. Didn't
realize you actually had a value problem.

"JLatham" wrote:

Use the Format Painter? It's the little paint brush looking thing: in Excel
2003 and earlier, it's the icon in between the paste-from-clipboard and Undo
icons in the standard icon bar. In Excel 2007 it's on the [Home] tab, in the
Clipboard group; the bottom icon of the 3 at the left of the big Paste
dropdown.

"SITCFanTN" wrote:

I feel silly asking this because I know it should be easy, but I just can't
figure this out. I have an Excel Spreadsheet and the data is in General
format and displays with one decimal and with the percent sign like this:
85.1% or 96.3%. I need to use this data in calculations so I need it to be a
number format as 85.1 or 96.3...with no percent sign. I can I accomplish
this. I have hundreds of rows of data that I need reformated in this way.
Thanks for your help.