why does it only bold the number in red when i apply the % style?

  • Thread starter Thread starter senorita2009
  • Start date Start date
S

senorita2009

Why can’t 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?
 
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 said:
Why can’t 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?
Click to expand...
 
Back
Top