View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Stop Excel Changing Format

What you want to enter is not a date (to Excel). It's two numbers separated
by a slash. So your choices a

1. Precede your entry with an apostrophe (')
2. Preformat your cells as Text.

Regards,
Fred.

"Chris762" wrote in message
...
In Excel I want to just show a date as dd/mm in a cell. Every time I enter
this Excel shows the number in dd/mm/yy format, even when I change the
cell
to use the General format. Any idea how I get Excel to show the number as
I
want?