Help with Excal Macro

  Pedro Campos 16:12 19 Oct 09
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 09

No macro needed. With your date in A1

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

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced