I actually had this exact same problem! It's as simple as adding a
space bar to the end of your number!

Do that makes the cell contents 'text'; -undesirable results will occur
in formulas referencing those cells!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion