Thread: macro to rearrange numbers in cell?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default macro to rearrange numbers in cell?
glad to help

--
Don Guillett
SalesAid Software

"jim" wrote in message
ups.com...
Thank you both. I ended up using the macro as a subroutine named
"CleanUp" and then reformatted the cells as a date 03/14/01.

-Jim


 wrote:
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