Thread: Format Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SITCFanTN SITCFanTN is offline
external usenet poster
 
Posts: 84
Default Format Question

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.