View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Address number changes to calendar format

I don't see how 5/11 could change into 5-June. Either it could be
interpreted as 11th May, or as 5th November, depending on your regional time
settings !!

Pete

"timbo2008au" wrote in message
...
Whenever i input house address eg 5/11 Smith St, the 5/11 changes to
5-June.
How do I stop this and/or change the 5-June back to 5/11?