Exactly what is in B9 and how is the cell formatted?

--
Rick (MVP - Excel)


"Cook" wrote in message
...

Hey Simon... how it going?

Changing it to .Text didn't seem to work... Any other ideas. It's
really not that big of a deal. More annoying than anything. UGH!


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59817