View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gilles Desjardins
 
Posts: n/a
Default 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
...