LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 89
Default Conversion help

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
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
conversion djl Excel Discussion (Misc queries) 1 February 1st 09 09:19 AM
Conversion to value between 1 to 10 only! wilchong via OfficeKB.com New Users to Excel 5 May 23rd 08 02:10 PM
Day Conversion Michael Excel Worksheet Functions 3 September 10th 07 11:40 PM
ESN conversion jay-rod Excel Worksheet Functions 2 April 29th 07 11:36 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM


All times are GMT +1. The time now is 08:01 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"