| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 97 formula doesn't work in Excel 2003
I recently switched from Excel 97 to Excel 2003.
When I open one of my spreadsheets created with Excel 97, all the the cells in columns B display #NAME?. There is also a green triangle in the upper left corner of each cell. The formula in each of the cells of column B is a variation on =QuarterNum(D642). This appears in cell B642. Column D has dates in it, and column B has quarter numbers. The formula in cell B642 is supposed to compute the quarter number based on the date in cell D642. This works when I open the file with Excel 97. How may I fix the file so it will work in Excel 2003? Will in Seattle a.k.a. "Clueless" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Link pictures in Excel 2003 doesn't work! | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| edit formula bar in excel 2003? | New Users to Excel | |||
| EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Threaded Mode
