Thread: Date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Date format

Hi! I have a program that exports data to Excel. The problem is that the
dates are in a format that is not recoginzed by Excel as dates. They look
like: 1997-maj-08, 1997-sep-24, 2005-jan-10 and so on. Is there any way to
covert these dates into normal Excel dates? If you know of a solution in VBA
instead of a worksheet function that would fine too! Thanks alot!