Anyone have ideas on this...

Can I have a comma appear when I'm typing data into a cell (to seperate
thousands)? I have the cell formatted the way I want after I press
enter, but I'd like the commas to show when I'm entering the data.

Thank you in advance.

-M