View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Stop Excel Changing Format

Format as dd/mm
--
David Biddulph

"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?