spreadsheet switches to bold involuntarily messing up figures

  • Thread starter lovely lavender lady
  • Start date
L

lovely lavender lady

This is Microsoft Office 2003. I'm typing out end-of-year audit for
accountant. sometimes when I type in a number in the column,it changes to
bold automatically without me asking it to.This totally messes up the total
figure at the bottom of the column. what am I doing wrong?
 
B

broro183

hi,

Could you be accidently holding the Control key down while pressing th
"B" key on the keyboard?
(this is the keyboard shortcut for changing cells or font to bold)

Other possible options include some sort of formatting macro in th
file, or "Conditional Formatting" (look this up in the Excel Help Files
which could include a Rule to apply bold formatting numbers over
certain amount.

hth
Rob
 
T

tim m

lovely lavender lady said:
This is Microsoft Office 2003. I'm typing out end-of-year audit for
accountant. sometimes when I type in a number in the column,it changes to
bold automatically without me asking it to.This totally messes up the total
figure at the bottom of the column. what am I doing wrong?

Sounds like you may have some kind of conditional formatting going on for
those cells perhaps.

The first thing I would try would be to hi-light all of the cells you are
typing your numbers in and format them to number or currency if they are
dollars and cents.
 

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

Top