I would like to be able to type a number into a cell and have it automatically converted to a number with the last 2 numbers to the right of the decimal point. For example, if I typed in 1234, it would become 12.34. How can I do that?
I would like to be able to type a number into a cell and have it automatically converted to a number with the last 2 numbers to the right of the decimal point. For example, if I typed in 1234, it would become 12.34. How can I do that?
Tools>Options>Edit
Check Fixed decimal places
Set for 2
Does that help?
Ron
Yes, that is exactly what I want. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks