Insert a column before it, and fill it with "'000", don't forget '
Then concatenate those two rows, that should do it.
You can copy paste values and delete the other two columns to get it
back to the same way it was before. If you click into it will take
your 0s away, not fair I know. You won't have that problem if you keep
the formulas there.

Hope that help,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=501802