lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
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.