Thread: Date Format in Spreadsheet different from menu bar how to fix?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
  
Posts: 189
Default Date Format in Spreadsheet different from menu bar how to fix?
Hi,

You can also do it this way

MenubarFormatCellsNumber tabDateRegional settings

or

Right click on the cellFormatCellsNumber tabDateRegional settings
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Geoff" wrote:


Using MS excel 2003, the date in spreadsheet is showing as NZ / Australia
format, the date in menu bar up top is showing in the American format.

How do we get them to be the same?
Reply With QuoteReply With Quote