Comma Style button

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

How do I use the comma style button on the tool bar?
I'd like to make 32759 look like 32,759 without adding in
the comma and copy the formula to the rest of the column
of numbers. I selected the cell I'd like to change, by
using the mouse, then selected the comma button on the
tool bar and received ##### as the answer.

If you could send back a reply, I'd appreciate it.
thanks so much.
 
Lisa,
Making the column bigger might help with that. This (#####) is Excel's way
of telling you the data is too big to be displayed in the current column.
Chris
 
Lisa

May be easier to Format>Cells>Number. Checkmark "use thousands separator"

The #### may be due to 32759 now looking like 32,579.00 and you don't have
autofit checked for that column.

Gord Dibben Excel MVP XL2002
 

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

comma style button 1
About comma style in MS Excel 1
Applying Indian comma style 1
Comma Style Question 3
display list selection in a different cell 2
copying excel info into word 2
Comma Style format, default change 1
How to use Windows command within Excel macros 2

Back
Top