Adrienne,

Try removing and Conditional Formatting that may have been applied.

HTH,
Bernie
MS Excel MVP


"Adrienne" wrote in message
...
I downloaded the checkbook register from Microsoft.com and am trying to add
a
few cells at the end to quickly calculate my outstanding debits and
credits
so that I can balance my statements automatically. I figured out how to
write
the formula properly (eventually), but the cells will not take on the
currency format no matter what I do. I have tried pasting the format from
the
other cells within the register, tried clearing the format and reapplying
the
currency format, tried accounting, etc.