Thread: date conversion from m/d/yyyy to yyyymmdd
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
  
Posts: 620
Default date conversion from m/d/yyyy to yyyymmdd
Jeff,

See response in misc group

--

HTH

Bob Phillips

"jeff" wrote in message
...
I have a cell with a custom date format of m/d/yyyy h:mm,
I need to convert the date to yyyymmdd text. Does anyone
have a VB macro code snippet to do something like this?
I've tried text to columns but can't get it to work...any
help is appreciated.

Thanks.



Reply With QuoteReply With Quote