I am affraid that can not be done. That feature is not supported directly by
Excel and no macros fire while you're editing a cell.
--
HTH...

Jim Thomlinson


"michael" wrote:

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