How about

=A1 & "/" & TEXT(TODAY(),"YY") & "/" & A3

--
Kevin Vaughn


"ChrisMattock" wrote:


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