Automatically entered decimal point.
Thanks Pete. I'm now experimenting with overriding columns to zero decimal
points to see if that will take precident over the edit. I just knew that
there had to be a way! I appreciate the quick reply too!
"Pete_UK" wrote:
Yes, you can do this. Click on Tools | Options | Edit (tab) and check
Fixed Decimal with 2 places, then OK. Enter the following values in
some cells:
123 -- displayed as 1.23
1234 -- displayed as 12.34
12345 -- displayed as 123.45
Note that if you have no cents, you will still have to enter 00 at the
end of the dollars.
It is probably better to de-select this option once you have finished.
Hope this helps.
Pete
J.G.Martin wrote:
I enter a lot of currency with cents and have to pick-up the decimal point
when the cents is not 00. Is there a way that I could simply enter a number
such as $43785 and have the decimal point be automatically positioned between
the 7 and 8 so that it read $437.85?
For a product as sophisticated as Excel, especially since it works with
money, one would think that this would be one of the first formatting options
available with a cell that concerns numbers and money.
Hope someone can offer a solution!
|