Thread: Change date format throughout workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
  
Posts: 180
Default Change date format throughout workbook
yo can select the desired cells and change it from the cell properties by
right clicking or by using shortcut key Ctrl+1.

You can use Custom option and set your date format.

Regards,
Pranav Vaidya

"C Tate" wrote:

Can I change the date format throughout an entire workbook, perhaps via find
and replace?
Reply With QuoteReply With Quote