none
Excel 2010 - Issue with formula copy not produce correct results

    Question

  • I am having an issue when copying certain types of formulas.  The issue is that the cells where the formula is copied do not initially display the formula results, it just pastes the results from the copied cell.

    For example, say I have a series of date data points - D2 = 07/25/2010, D3 = 08/30/2010, D4 = 09/30/2010 and I want to use a formula that converts these dates to a "yyyy/mm" text.  The formula I use is =TEXT(D2,"yyyy/mm").  When the formula is placed in cell E2 it returns the value of 2010/07, but when I copy the formula to E3 and E4 it returns the same value of 2010/7.  Only when I double click the E3 and E4 will Excel return the correct calculated value of 2010/08 and 2010/09.

    This same issue happens if I use a formula similair to =LEFT(cell,6)

    Any ideas?

     

     

    Tuesday, July 26, 2011 6:06 PM

Answers

  • This looks like manual calculation. See what happens if you press F9. Go to File|Options|Formula and make sure the calculation is set to automatic.
    Wednesday, July 27, 2011 8:53 AM

All replies

  • This looks like manual calculation. See what happens if you press F9. Go to File|Options|Formula and make sure the calculation is set to automatic.
    Wednesday, July 27, 2011 8:53 AM
  • That is the fix, thanks for your help

    Monday, August 15, 2011 10:50 PM
  • I confirm that File|Options|Formula is set default "automatic" but the problem prevails.   Any suggestions?

    Wednesday, March 28, 2012 12:40 PM