Format Painter Error
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? |
Format Painter Error
ToolsOptionsCalculation.
Checkmark in "Automatic" Gord Dibben MS Excel MVP On Fri, 13 Oct 2006 15:08:02 -0700, Bruce Lee-Roy <Bruce wrote: 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? |
All times are GMT +1. The time now is 09:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com