Thread: macro to rearrange numbers in cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bodhi2.71828@gmail.com is offline
external usenet poster
  
Posts: 22
Default macro to rearrange numbers in cell?
Or you could do:

=DATE(LEFT(B2,4),MID(B2,5,2),RIGHT(B2,2))

(assuming date is in cell B2)

Then you could use whatever format you want for the date via menu item
Format | Cells.

Reply With QuoteReply With Quote