Date conversion macro exists? (Excel)
Thread poster: Csaba Ban

Csaba Ban  Identity Verified
Hungary
Local time: 13:50
Member (2002)
English to Hungarian
+ ...
Dec 9, 2004

I have two enormous Excel files, with 25 sheets in each of them, and around 40 rows in each sheet.
In far too many cases there are dates embedded in text. Is there any way I can easily mass-convert such dates into my target language?

The source dates are in American format:
mm/dd/yyyy, etc. 12/09/2004
I would need them in Hungarian format:
yyyy. mmm. dd., etc. 2004. dec. 9. (or 09)

I suspect there is no easy way to do this. Again, these are not the only content of the cells, but most of the time they are within some text.

If someone else has encountered a similar task and perhaps developed a macro for it, could you share it with me please? (I could adapt it with a list of Hungarian months)

Else, can you give me a hint on how to do this?

Thank you... this would save many many hours.


 

Harry Bornemann  Identity Verified
Mexico
English to German
+ ...
Can you export the sheets to .txt files and reimport them? Dec 9, 2004

Hi Csaba,

In text format I could easily write an .exe program in Perl to do this conversion (half an hour?).

But my knowledge of Excel VBA is too poor for this (several days?).

Cheers,

Harry

PS: In Excel 2000 I can export all of the sheets at once to HTML (which I consider as text format) and reimport them together..

[Edited at 2004-12-09 21:22]


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Date conversion macro exists? (Excel)

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search