Ummmm.....obvious typo:

intend that to be 01-Jan-2006

Should be:
intend that to be 04-Jan-2006



"Ron Coderre" wrote in message
...
You're right. Excel needs a way to differentiate a date from a
fraction.....
a leading number followed by a space suffices.

A1: 0 1/4 X 0 1/4
Perform text-to-columns (with "X" as the delimiter)

Here's the result:
A1: 1/4
B1: 1/4
(both are decimal numbers displayed as fractions)

I assume that the overwhelming majority of user who enter 1/4, intend that
to be 01-Jan-2006 versus 0.25, hence the leading number requirement for
fractions.
***********
Regards,
Ron

XL2002, WinXP


"Epinn" wrote:

Ron,

Thank you for making my Text to Columns idea work better by suggesting
formatting the columns to number first. This is fascinating.

(the type coercions are automatic when the number format is NOT
General) <<

As indicated in my previous post, Text to Columns won't work with
fractions without integers.

A1: 1/4 X 1/4

Text to Columns returns

A1: 38721.00
B1: 1/4

Don't understand why.

Epinn


"Ron Coderre" wrote in message
...
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