| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming
|
|||
|
|||
Excel Formula in XP and NT
Hi all,
I have an excel macro running in NT4.0 + Office97 and I have use some formula such as EMONTH... After upgrade to XP + Office97, I find the formula is less than in NT, eg. Emonth cannot be find in the "Date and Time" formula. Is it because of compatiable of the XP and Office97? Will Office2000 or OfficeXP resolve this? Thanks, Jack |
|
#2
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming
|
|||
|
|||
|
Excel Formula in XP and NT
Hi Jack
EOMONTH is one of the analysis tool-pak add-in formulas go to tools / add-ins - check analysis tool-pak to enable. Cheers JulieD "msenquiry" wrote in message ... Hi all, I have an excel macro running in NT4.0 + Office97 and I have use some formula such as EMONTH... After upgrade to XP + Office97, I find the formula is less than in NT, eg. Emonth cannot be find in the "Date and Time" formula. Is it because of compatiable of the XP and Office97? Will Office2000 or OfficeXP resolve this? Thanks, Jack |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
