ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. (https://www.excelbanter.com/new-users-excel/10561-office-97-2003-excel-enter-data-w-fixed-2-decimal-2000-a.html)

terrier

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?


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com