How to setup for automatic decimal. [closed]
My accounting software and my accounting calculator both do a really handy thing: they insert the decimal for me. If, for example, I type in 123456, it will be automatically converted to $1234.56. If I type 1200 it will become 12.00 unless I override by typing in the decimal where I want it. So if I want 1200.00 I can either type 1200. or 120000. Both my calculator and my numeric keypad have a 00 key to make data entry faster when you have lots of zeros.
SO, is there any way to do this in calc? Is it a setting somewhere, or a number format that I can't find or what?
Thanks.
I bet the replacement is something a macro could do, but probably only after a keypress, so it would only save you some key presses.
There would be no point to that. If I have to push an extra key I'll push the dot. The real point is that when you enter a LOT of monetary amounts on an accounting calculator or into accounting software, you get into a rhythm which allows you very fast and accurate data entry. Having to constantly remember to put in the decimal - when the computer should be able to do that for you - and having to backspace every few entries when you forget the decimal, or having your data full of errors because you didn't notice that you forgot the decimal really messes things up. Without the automatic decimal, this just isn't professional level accounting or bookkeeping software. I suppose it's great as a general purpose spreadsheet, making presentations or for people who don't routinely do a lot of bookkeeping, but that's about it.