View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default stop fractions changing to dates

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



John wrote:

trying to put 5/5 into a cell and automatically changes to 5-may. how do I
stop this?


--

Dave Peterson