How to change default value of comma style

K

Khoshravan

When I click comma style icon for thousands separator, it always adds to
digit after decimal point. How can I change the default value to add zero
digit after decimal point.
12345 => 12,345.00 but I want 12,345
 
D

Dave Peterson

I may have misunderstood the OP's question (it happens way to often with me!),
but I thought the OP really wanted to know an answer to this:

BTW is comma style only defined for currency?
 

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 does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
creating new template - change default heading style 7
How to format without decimal point unless significant digits? 3
Decimal Points and comma separators 2
Need help modifying code 0
Excel 2002 : How to set thousand separator at tool bar ? 2
comma style button 1

Top