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

G

Gilles Desjardins

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
 
T

TheGreatLadyJ

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