You can scale either a single cell or a range of cells ( column, row,
whatever). In an unused cell enter
..5
and copy this cell. Then select the cells you want to adjust and
paste/special with multiply checked.
--
Gary's Student
gsnu200712


"lili" wrote:

how do I make a cell equal half of whatever $ amount I put in?
If I type in 23.50 (Accounting format) I want it to say $11.75