Thread: Convert text date to general number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Andrew is offline
external usenet poster
  
Posts: 358
Default Convert text date to general number
Hi,

I have a text value for the date. I want to convert it to a number (ie
from 190707 to 39282). Please note the format of the date is ddmmyy
--
Andrew
Reply With QuoteReply With Quote