Thread: How to create a date conversion in MS Excel using VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandspirit Sandspirit is offline
external usenet poster
  
Posts: 1
Default How to create a date conversion in MS Excel using VBA
Hi,

I have a file that is imported from Attachmate Extra!. The dates appear
in Excel as i.e. 106/04/14, which represents April 14, 2006. How can I
convert all these dates to the standard 04/14/2006 format using VBA? I
have NEVER seen a date format like the one from Attachmate. Please
help.

Thanks!

Sandspirit

Reply With QuoteReply With Quote