how to stop fractions in a columm automatically changing to dates
 

Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that?

how to stop fractions in a columm automatically changing to dates
 

put an apostrophe in front '05/05 or format the cell as a date.

--

Gary Keramidas
Excel 2003


"John" wrote in message
...
Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that?

how to stop fractions in a columm automatically changing to dates
 

Either pre-format the cell as TEXT or, precede the entry with an apostrophe
like this '5/5.

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that?

how to stop fractions in a columm automatically changing to dates
 

--Right click the cell/rangeFormat CellsCustom Type
0/0

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that?

how to stop fractions in a columm automatically changing to dates
 

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

--
Steve

"John" wrote in message
...
Just trying to enter 5/5 into a cell. But automatically changes to 5-may.
How do I sto that?

how to stop fractions in a columm automatically changing to dates
 

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.
--
David Biddulph

"Jacob Skaria" wrote in message
...
--Right click the cell/rangeFormat CellsCustom Type
0/0

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

Just trying to enter 5/5 into a cell. But automatically changes to
5-may.
How do I sto that?

how to stop fractions in a columm automatically changing to da
 

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
---------------
Jacob Skaria


"David Biddulph" wrote:

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.
--
David Biddulph

"Jacob Skaria" wrote in message
...
--Right click the cell/rangeFormat CellsCustom Type
0/0

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

Just trying to enter 5/5 into a cell. But automatically changes to
5-may.
How do I sto that?