Confirmed, until v ersion XP you could finish off with a decimal separator.
This behavior changed with Excel 2003, I haven't seen any documentation on
"Enter decimal" is like
which is just as many keystrokes as
If you deal with blocks of data, it's easy to create a macro that handle
selected cells and multiplies by / divides by 100. This may be faster than
typing each one, post back if you want me to write one for you. But if those
cells are scattered all over then I guess there is no cure except digging up
an earlier version of Excel for entry.
HTH. Best wishes Harald
"terrier" <firstname.lastname@example.org> skrev i melding
> When I enter number "2000." I get 20.00 - yes, set decimals at 2 but
> excel would accept change if you entered decimal with number. this is
> slowing down a budget prep and I'd sure like some help - online and
> say "enter decimal" but this is not working. what am I doing wrong?