How do I have excel convert fractions to decimals?
Here's another option
With
A1: 16 3/8 X 5 1/8
Then
1)Format cellls A1 and B1 as Category: Number
2)<data<text-to-columns
Delimited
Check: Other and use: X
Click the [finish] button
A1 becomes 16.375
B1: becomes 5.125
(the type coercions are automatic when the number format is NOT General)
***********
Regards,
Ron
XL2002, WinXP
"Ron Coderre" wrote:
Perhaps one of these:
Using
A1: 16 3/8 X 5 1/8
Translated to decimal:
B1: =(--TRIM(LEFT(A1,SEARCH("X",A1)-1)))&" X
"&(--TRIM(MID(A1,SEARCH("X",A1)+1,255)))
returns 16.375 X 5.125
Or...
B1: =--TRIM(LEFT(A1,SEARCH("X",A1)-1))
returns 16.375
B2: =--TRIM(MID(A1,SEARCH("X",A1)+1,255))
returns 5.125
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"pgail" wrote:
I am typing in measuments of packages - i.e. 16 3/8 X 5 1/8, I want excel to
convert to decimal. I have tried format cells, and convert, neither have
this option available.
"Ron Coderre" wrote:
Can you give examples of how you need to deal with the fractions?
Are you typing them?
Are they in data that was imported?
Are you referring to them in another cell?
What have you tried?
What were you hoping for?
What were the actual results?
***********
Regards,
Ron
XL2002, WinXP
"pgail" wrote:
I am trying to convert fractions to decimals
|