Excel Cell Formatting Question

[MrMeric]

Do you know if there is a way when keying in numbers using 10 key that you can set up a spread sheet to automatically insert the decimal point? Example I key 12345 and want it to enter as $123.45. I tried to format the sheet using 2 decimal points but it enters it as $12,345.00 vs. $123.45.

 

[SkipVought]

Hi,

Tools/Options -- Edit Tab -- Check Fixed Decimal with the number of places.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}