Krem, thanks for your 2nd reply, I have tried the auto format feature
and whilst not ideal it certainly gives me some options.
Thanks for your help :)
Amy x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=37943