Comma Shows When Typing

  • Thread starter Thread starter mcastellano
  • Start date Start date
M

mcastellano

I'm not sure this is possible, but can I have a comma appear when I'm
typing data into a cell? I have the cell formatted the way I want after
I press enter, but I'd like the formatting (commas most importantly) to
show when I'm entering the data.

Thank you in advance.

-M
 
Do you mean to show commas to separate a number into thousands etc.? If
so, then I don't think this is possible - as you type in the numbers to
make 1000000, for example, Excel will not know in advance how many
keystrokes you are going to make, so you can't expect it to put a comma
after the "1" and after the "1,000" for you.

Hope this helps.

Pete
 
Yes, that's exactly right Pete. I didn't think it was possible, but if
anyone has any ideas on how to do this - please pass them along. Thank
you again!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel won't let me type a formula using commas! 5
Commas appear when typing 1
Excel VBA - Force 4 commas into a text field on userform 7
Differences Between Two Spreadsheets ? 1
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
How to keep loaded file's format intact? 1
somewhat complicated conditional formula 2
problems when saving as comma delimited text file 1

Back
Top