Whilst there isn't any way per se to do what you are asking, take a look
at http://www.excelforum.com/showthread.php?t=374128. You could
experiment with text instead of numbers and convert it back to numbers
behind the scenes. re. the apostrophe, I prefer to pre-format the
cells as text.

Not the answer you were looking for, but I hope this helps a bit.

Martin


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=374515