Excel uses the single quote to force data to align to the left cel
border.

Your VB solution will be the same as the manual one. Add another quot
to your user's entry when inserting into the cell

--
Message posted from http://www.ExcelForum.com