ExcelBanter - Commas appear when typing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Commas appear when typing (https://www.excelbanter.com/excel-programming/364413-commas-appear-when-typing.html)

michael

Commas appear when typing

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

Jim Thomlinson

Commas appear when typing

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

All times are GMT +1. The time now is 02:08 AM.