J
John
Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that?
How do I sto that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary Keramidas
put an apostrophe in front '05/05 or format the cell as a date.
T
T. Valko
Either pre-format the cell as TEXT or, precede the entry with an apostrophe
like this '5/5.
like this '5/5.
J
Jacob Skaria
--Right click the cell/range>Format Cells>Custom> Type
0/0
If this post helps click Yes
0/0
If this post helps click Yes
A
AltaEgo
Try entering an inverted comma before the fraction.
'5/5
Or did you want Excel to evaluate the fraction? if so place an equals sign
first
=5/5
'5/5
Or did you want Excel to evaluate the fraction? if so place an equals sign
first
=5/5
D
David Biddulph
Doesn't that display as 39938/1 rather than 5/5 ?
Formatting as d/m would display as 5/5, but of course it would still be a
date.
Formatting as d/m would display as 5/5, but of course it would still be a
date.
J
Jacob Skaria
Thanks David.. I mean to say preformat the cells. But still it would display
5/5 as 1/1..
If this post helps click Yes
5/5 as 1/1..
If this post helps click Yes