Help with Excal Macro

  Pedro Campos 16:12 19 Oct 2009
Locked

Hello there...

I have a cell with a formula of =TODAY() wich gives today's date i.e. 20 October 2009 but i want to use this date and incorpotate it into another cell possibly using =CONCATENATE fomulas so that the result is XN200910PC00530. As you can see i would have something like =concatenate("XN",the date in the format ddmmyy,"PC00530").

Thanks

  VoG II 16:40 19 Oct 2009

No macro needed. With your date in A1

="XN"&TEXT(A1,"ddmmyyyy")&"PC00530"

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

WWDC history: Apple's product launches since 2005

Comment importer des contacts d’un iPhone à un autre iPhone ?