Fixed Decimal

[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?

 

[Frank Kabel]

Hi
it always affect the entire workBOOK

 

[Norman Harker]

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.