Shamelessly stealing an idea from Bob Philips:

=RIGHT("0000"&A1,4)&B1

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"pc300d" wrote in
message ...

The JPEG is a bit naff, here's a Word doc that's better.

Regards


+-------------------------------------------------------------------+
|Filename: Excel Help.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4628 |
+-------------------------------------------------------------------+

--
pc300d
------------------------------------------------------------------------
pc300d's Profile:
http://www.excelforum.com/member.php...o&userid=33474
View this thread: http://www.excelforum.com/showthread...hreadid=532785