Hi
Without using an extra column, you can't.
Even with VBA, if you run code to change the appearance of the cells,
the underlying values themselves would alter.


--
Roger Govier
------------------------------------------------------------------------
Roger Govier's Profile: http://www.thecodecage.com/forumz/member.php?userid=81
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82544