Thread: how do I change the date format from yyyymmdd to mm/dd/yyyy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default how do I change the date format from yyyymmdd to mm/dd/yyyy
Hi,
highlight the range, right click on the mouse, custom format, type mm/dd/yyyy

"Charlene" wrote:

how do I change the date format from yyyymmdd to mm/dd/yyyy
Reply With QuoteReply With Quote