Pack

Junior Member

Posts: 1

Converting Fraction that is in text form into decimal

Import data with fractions like this 44"1/16 so it reads it as text and not number. I need a formula to turn it into decimal numbers so I can use them in equations.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Fraction to Decimal	Michael Dugan	Excel Worksheet Functions	2	February 13th 13 03:27 AM
Fraction to decimal	Alvin	Excel Programming	2	April 18th 10 10:48 PM
How can I turn a fraction into a decimal.	Megan	Excel Worksheet Functions	0	October 15th 09 04:49 PM
formula for converting decimal to inch & fraction	davepatrob	Excel Discussion (Misc queries)	1	December 31st 05 03:10 PM
How do I change a text fraction. eg 1 1/2 into a decimal number, .	antac	Excel Worksheet Functions	1	February 28th 05 05:02 PM

All times are GMT +1. The time now is 02:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us