Fixed Decimal

  • Thread starter Thread starter KPLP
  • Start date Start date
K

KPLP

Does anyone know if it is possible to contain the Fixed
Decimal feature (Tools, Options, Edit)to just one column
rather than the whole worksheet?
 
Hi KPLP!

If you have a large number od numbers to enter in a column and you want the
fixed number capability, you could use a helper column.

So if you wanted 2 fixed places for entries to column A, you could insert a
column B and use the formula:

=A1/100
Format to two decimal places.

After data entry, you can select the column B and use:

Copy > Edit > Paste Special > Values > OK

The column A entries can then be deleted.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top