Hey all,
Just need some quick help, need to have a cell show this....
GAP/06/21300
Where...
GAP comes from Cell A1
06 comes from Cell A2 (Currently I'm using "=year(now())", but tht
gives 2006, not 06)
21300 comes from A3
Optimisticly tried =A1,"/",A2,"/",A3, obvioulsy didn't work, Im not
great at this btw!
--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile:
http://www.excelforum.com/member.php...o&userid=33912
View this thread:
http://www.excelforum.com/showthread...hreadid=553516