| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't conditionally format, receive this error message: "Excel cou | Excel Discussion (Misc queries) | |||
| Can I assign a shortcut key (alt letter) to the format painter | Excel Discussion (Misc queries) | |||
| how can I use the format painter?? | New Users to Excel | |||
| format one data series, with error bars, and use it as default | Charts and Charting in Excel | |||
| Format Painter button problem | Excel Discussion (Misc queries) | |||
Linear Mode
