entering 4/5, 6/9, 5/6 numbers

[lezawang]

Hi
I want to enter number like 4/5, 6/9, 3/5 number in that way. So I formatted the cells as #/#.
But when I enter 4/5, excel will convert it to 04-May, and when I enter 6/9 excel will convert it to 06-sept
only if numbers greater than 12 then excel wont change it to date. for example 17/19 excel will cover it to 8/9 which is fine
but for numbers less than 12 excel will cover them to date. How can I fix that.
Thank you so much.

 

[mrshl9898]

Hi,

• Select the cells that you want to format.
• On the Home tab, click the Dialog Box Launcher next to Number.
• In the Category list, click Fraction.
• In the Type list, click the fraction format type that you want to use.

 

[Tom Urtis]

Using your example of 4/5, simply type in a zero and a space and then 4/5. The result will be a numeric entry that visually in the cell looks like 4/5 (because it is), and in the formula bar you'll see 0.8 because that's what it is.

 

[Rick Rothstein]

Do you really need your values to be real fractions that you can do calculations with or are they just codes or ID's of some kind? If the latter, simply format your cells as Text before you enter any values into them and Excel will no longer convert them to dates.