View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Curt Charles PDX Curt Charles PDX is offline
external usenet poster
 
Posts: 1
Default Wrong date format in header

In Control Panel I have the default short form date set to dd-MMM-yy
(24-Oct-06). In an Excel header or footer the date format defaults to
dd-mm-yy (24-10-06).

How can I get the Excel header date to be in dd-MMM-yy format?