ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why does it only bold the number in red when i apply the % style? (https://www.excelbanter.com/excel-discussion-misc-queries/244572-why-does-only-bold-number-red-when-i-apply-%25-style.html)

senorita2009

why does it only bold the number in red when i apply the % style?
 
Why cant I just use the % button on the Formatting toolbar? Why when I
click on that button it gives me red bolded number but not the percentage
formatting?

Dave Peterson

why does it only bold the number in red when i apply the % style?
 
I'd guess that the % style in this workbook was changed by someone.

In xl2003 menus:
Format|Style
Select percent
Click modify and change what you want.

Styles live in workbooks. So you'll have to make the same adjustment to each
workbook that has the problem.

If you can find a workbook that has the correct formatting for the percent style
(maybe a brand new workbook???), you could merge styles.

Open the workbook with the good percent style.
Open the workbook with the bad percent style.

With the bad workbook active...
Format|style|merge
and choose to merge from the good workbook



senorita2009 wrote:

Why cant I just use the % button on the Formatting toolbar? Why when I
click on that button it gives me red bolded number but not the percentage
formatting?


--

Dave Peterson

senorita2009

how and where can i use the % button on the toolbar, examples plz?
 


"senorita2009" wrote:

Why cant I just use the % button on the Formatting toolbar? Why when I
click on that button it gives me red bolded number but not the percentage
formatting?



All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com