Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be.

When I enter number "2000." I get 20.00 - yes, set decimals at 2 but earlier 
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 tutorials 
say "enter decimal" but this is not working.  what am I doing wrong?
0
terrier (2)
1/29/2005 6:11:04 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
559 Views

Similar Articles

[PageSpeed] 51

Hi

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
the reasons.
"Enter decimal" is like
2000.0
which is just as many keystrokes as
200000
but slower.

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" <terrier@discussions.microsoft.com> skrev i melding
news:B566AE9D-A0F3-4538-A204-26DEB7ACBCC4@microsoft.com...
> When I enter number "2000." I get 20.00 - yes, set decimals at 2 but
earlier
> 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
tutorials
> say "enter decimal" but this is not working.  what am I doing wrong?


0
innocent (844)
1/29/2005 10:59:53 AM
Reply:

Similar Artilces: