Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Question Jeremy Excel Discussion (Misc queries) 2 September 28th 09 03:07 PM
format question Bassman New Users to Excel 4 July 27th 08 07:26 PM
Yet Another Name Format Question Dallas PM Excel Discussion (Misc queries) 3 April 1st 08 10:01 PM
Format question Richard Excel Discussion (Misc queries) 3 March 8th 08 03:00 PM
Format Question VegasBurger Excel Worksheet Functions 2 June 24th 06 06:34 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"