trying to put 5/5 into a cell and automatically changes to 5-may. how do I stop this?
J John Aug 5, 2009 #1 trying to put 5/5 into a cell and automatically changes to 5-may. how do I stop this?
D Dave Peterson Aug 5, 2009 #2 Preformat the cell as text (Format|Cells|Number tab in xl2003 menus) Then do the data entry or start your entry with an apostrophe: '5/5
Preformat the cell as text (Format|Cells|Number tab in xl2003 menus) Then do the data entry or start your entry with an apostrophe: '5/5
