How do I have excel convert fractions to decimals?
Text to Column only works when there is an integer to the left of the fraction, e.g. 11 1/4.
If it is a fraction on its own, say 1/4, Text to Column will treat it as a date.
Wonder if there is a way to get around this.
Epinn
"Epinn" wrote in message ...
Roger and Ron,
I learn a couple of things. Thanks. I was hoping that Text to Column could do some magic. But no luck.
The best it can do is to split 16 3/8 X 5 1/8 in A1 into
A1: 16 3/8
B1: 5 1/8
After formatting to general
A1: 16.375
B1: 5.125
C1: =A1&" X "&B1 returns 16.375 X 5.125
You know I had this "crazy" idea that there might be some hidden features in Text to Column that would convert 16 3/8 X 5 1/8 to 16.375 X 5.125 in one shot. I guess no other features will do this either. I am over imaginative.
By the way, I really like the fact that the double unary coerces the fraction to decimal.
Thanks for listening.
Epinn
"Roger Govier" wrote in message ...
Hi
If the cell is formatted as fraction, just FormatCellsGeneral
or if you want to retain both, assuming the fraction is in A1 then in
another cell =A1 and format that cell as General.
If the fraction has been entered as text in a cell then
=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,255)
--
Regards
Roger Govier
"pgail" wrote in message
...
I am trying to convert fractions to decimals
|