Format Painter Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a formula to calculate the amount of days in between 2 dates. I'll
enter the formula as "=f2-today()" and when I hit enter, the results show up
in the cell and then I'll go through the FORMAT PAINTER process and instead
of getting a different number result for each cell, I just get duplicates of
the same number that I got when I ran the first formula. What am I doing
wrong?
 
Tools>Options>Calculation.

Checkmark in "Automatic"


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 15:08:02 -0700, Bruce Lee-Roy <Bruce
 
You must log in or register to reply here.

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

Using Format Painter on multiple cells 3
copy conditional format without using format painter 2
copy conditional formatting range 3
Copying formulas across columns 2
Match function: error due to format? 4
How can I edit the formula without changing the format? {=SUM(if. 1
Format painter 8
Format Painter not working in Word 2010 3

Back
Top