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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?