Thread: Date dd/mm/yy in the cell, but mm/dd/yy in formula bar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sfp sfp is offline
external usenet poster
  
Posts: 1
Default Date dd/mm/yy in the cell, but mm/dd/yy in formula bar
I am being supplied a file that displays date as 06/05/09 in the cell, but
05/06/09 in the formula bar. Cell is displaying the value I need, formula
bar is not. Cell is a 'custom' format. When I change to any other format
and try and put it back to date, it becomes 5 June instead of 6 May.

HELP!!
Reply With QuoteReply With Quote