On Thu, 26 May 2005 10:10:11 -0500, bailej03
wrote:


Posts: 1

Hi all,

Hoping for some help with a spreadsheet. What I would like to do is
format a range of cells such that the number is displayed as one of
this group {6 8 10 12 14 16 18 20 22 25 28 30 32 36 40 45 50 55 60 70
80}


Just an additional point. In Excel "formatting" usually refers to how a number
is displayed and not to what is actually in the cell.

If you actually want the cell to "contain" 60.0001 but "display" 70, that would
be quite difficult. I suppose a VB script could be written that would
superimpose a picture of the value to display over the cell, but I've not done
anything like that.


--ron