2/29 gets converted to 2/1 in excel. how do i change this?
 

2/29 gets converted to 2/1 in excel. how do i change this?
 

This is obviously not a fraction, SO, you have two options.
1- An apostrophe in front will enter what you want as text '2/29
2- If it is a fraction and you want to calculate it type 0(zero)space 2/29
This will create a real fraction that you can add, subtract, divide, etc.

HTH

Gilles
"TheGreatLadyJ" wrote in message
...

2/29 gets converted to 2/1 in excel. how do i change this?
 

it's not a fraction, it's just a date in a worksheet....thanks for your help.
it works.

"Gilles Desjardins" wrote:

This is obviously not a fraction, SO, you have two options.
1- An apostrophe in front will enter what you want as text '2/29
2- If it is a fraction and you want to calculate it type 0(zero)space 2/29
This will create a real fraction that you can add, subtract, divide, etc.

HTH

Gilles
"TheGreatLadyJ" wrote in message
...