View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChrisMattock
 
Posts: n/a
Default Simple stuff (Probably)


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