Automatic decimal point

[Ron H]

Years ago I used a spreadsheet program which allowed me to setup an option
for the decimal point so that when I entered a number: 123456, it would
automatically convert to 1,234.56.
I do not see where or how to do this in Excel. In my line of work, this
would be of get help to me. I hope someone can assist me with this. Thanks,

 

[Gary''s Student]

Tools > Options... > Edit > Fixed ecimal > 2

Use Format Cells... to get the comma

 

[Gord Dibben]

Excel 2007

Home Button>Excel Options>Advanced>Editing Options> Checkmark
"Automatically insert a decimal point" and set for 2


Gord Dibben MS Excel MVP