Forum Discussion
fixed decimal point data entry
I want to switch it off.
Excel offers a feature to automatically insert a decimal point:
File\Options\Advanced\"automatically insert a decimal point"
While this is a helpful feature, the down side is that is sets the input formatting for all Excel files; it's a global option. Is there a way to either use conditional formatting or a formula to set this feature for only a designated range of cells or column? I have set up a worksheet to calculate monthly expenses. It would be a great time saver to type in whole values and automatically insert the decimal point before the last two digits. Ex. Typing 555 would auto convert to 5.55.
It seems like this could be a custom format, something like: #,###.##—I tried that but it doesn't work. Why?
Seems like like all of Excel's extensibility this would be an easy fix!?
File\Options\Advanced\"automatically insert a decimal point"
While this is a helpful feature, the down side is that is sets the input formatting for all Excel files; it's a global option. Is there a way to either use conditional formatting or a formula to set this feature for only a designated range of cells or column? I have set up a worksheet to calculate monthly expenses. It would be a great time saver to type in whole values and automatically insert the decimal point before the last two digits. Ex. Typing 555 would auto convert to 5.55.
It seems like this could be a custom format, something like: #,###.##—I tried that but it doesn't work. Why?
Seems like like all of Excel's extensibility this would be an easy fix!?