Number Formatting Question

K

Kurch

How can I customize number formatting so that when I select "Number" I
don't have decimals and do have a comma? I would like to be able to
have an icon on my menu bar that allows me to reformat a number to
that outcome.

Also, can I change "Number" so that I get that outcome permanently?

Thanks
 
G

GS

After serious thinking Kurch wrote :
How can I customize number formatting so that when I select "Number" I
don't have decimals and do have a comma? I would like to be able to
have an icon on my menu bar that allows me to reformat a number to
that outcome.

Also, can I change "Number" so that I get that outcome permanently?

Thanks
Click to expand...

You can define 'Number' in your Normal Style, OR you can create a
custom Number Style that you could apply to cells 'on-the-fly' from the
Styles dropdown.
 

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

Formatting long decimal numbers as TEXT cell, not refreshing? 2
Typed numbers are divided by 10 (Excel 2007) 2
Automatically chnage number format of a range of cells 2
Excel Conditional Formatting 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Discrepancy in calculations with dollars and cents 10
Non-macro method (like conditional formatting) to insert text in cell? 7
Brute Force Guessing 2

Top