Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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" skrev i melding ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
How do I add Data Analysis Tool Pak to my Excel 2000? | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Automatic links in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |