Cell alignment using a comma

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

Please Help ASAP...
When we enter a number with a comma, the cell will not
align to th right or left. It appears to be stuck in the
center.
NOTE: It works with decimals fine it is just the comma
that prevents the alignment.
 
Laura

Sounds like it is changing to Accounting Style.

Check the formatting of the cell(s).

Also check out Format>Styles>Accounting and see what the format is.

Why are entering numbers with a comma?

Just enter as 12345 and format to Number, which should default to 12,345.00

Again, you can alter that in Format>Styles>Normal.

Gord Dibben Excel MVP
 

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 4
force alignment? 7
count no. of commas (,) in a string in a cell 3
Decimal tab aligning on comma? 5
How to count commas in a cell? 5
Why won't text show in SOME cells? 3
Convert number to text as displayed 3
text alignment settings 2

Back
Top