decimal places

[Sharp]

Hi,

Does anyone know a way that you can limit a user to entering numbers to 2 decimal places ONLY, in a specific column. So basically what is in the formula bar can only be to two decimal places

thanks

[FrankBoston]

Menus: Tools: Options: Calculation: Precision as Displayed
will convert any value entered to match the display format of the cell
For example, setting a numeric format to 2 decimal places will allow entering
2.346, but will display 2.35 AND will set the cell value to 2.35 .

Menus: Tools: Options: Edit: Fixed Decimal Places: 2
may help also.

If you want this behavior in only a column or a few cells, you can use the Worksheet_Change() event to check each entry and round it in the desired locations.

[Sharp]

How would i go about using the Worksheet_Change() event to affec just 1 column, as i only need to do it in 1 column

thanks

[FrankBoston]

See if this post answers your question.

http://www.excelforum.com/showthread...orkbook_change