Tools Options... Edit Fixed ecimal 2

Use Format Cells... to get the comma
--
Gary''s Student - gsnu200856


"Ron H" wrote:

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,
--
rshfl