Prev: create chart from daily data and add trend lines for each week
Next: Macro to hide worksheet based upon text in the name
From: JLatham on 8 Apr 2010 17:28
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.
First  |  Prev  | 
Pages: 1 2
Prev: create chart from daily data and add trend lines for each week
Next: Macro to hide worksheet based upon text in the name