Greetings,
I recently posted a request for assistance in formatting a cell to automatically place the decimal point two places to the right when I type in - say a 3 digit number, and not add two zero's at the end.
Example: I format the cell for 2 decimal points and type in the number 350. It adds two zeros and displays 350.00, rather than the desired 3.50.
I received multiple replies suggesting I go into Excel Options, Advanced, Automatically insert a decimal point..., which helped greatly. The problem I've noticed is it changed Excel 'globally', rather than that specific worksheet.
Question: Is there a way to apply it to an individual worksheet?
Thanks much,
I recently posted a request for assistance in formatting a cell to automatically place the decimal point two places to the right when I type in - say a 3 digit number, and not add two zero's at the end.
Example: I format the cell for 2 decimal points and type in the number 350. It adds two zeros and displays 350.00, rather than the desired 3.50.
I received multiple replies suggesting I go into Excel Options, Advanced, Automatically insert a decimal point..., which helped greatly. The problem I've noticed is it changed Excel 'globally', rather than that specific worksheet.
Question: Is there a way to apply it to an individual worksheet?
Thanks much,
