Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have data as shown below.
7/32" 11/32" 1/4" 3/8" 5/16" 7/16" 3/8" 1/2" I have changed the formatting for all cells to "numbers, 3 place decimals, then "copy,paste special, values". My problem is that when I do a find and replace (Ctrl-H) to golbally replace the quote marks with nothing, I get data like this: OLd Values: 7/32" 11/32" New values: 11871.000 11994.000 But if I go into each cell and delete the quote mark manually, it converts to the proper decimal equivalent. Unfortunately, I have several hundred of these to convert. Anyone know how to solve this? Thanks Iriemon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conversion | Excel Discussion (Misc queries) | |||
Conversion to value between 1 to 10 only! | New Users to Excel | |||
Day Conversion | Excel Worksheet Functions | |||
ESN conversion | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |