By preceding the 7/30 with a single quote (an apostrophe) as in '7/30 (the
quote will no display or print)
By formatting the cells as Text BEFORE entering data
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Chuckie" wrote in message
...
When I type 7/30 in a cell (signifying the date July 30th) and I move
to
the next cell it automatically changes it to 30-Jul .. which is
annoying.
How can I get Excel to not auto-reformat that? Thanks.