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