Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Question | Excel Discussion (Misc queries) | |||
format question | New Users to Excel | |||
Yet Another Name Format Question | Excel Discussion (Misc queries) | |||
Format question | Excel Discussion (Misc queries) | |||
Format Question | Excel Worksheet Functions |