Help Excel 2007 error

[mo2783]

Hello People

Someone created a program in excel 2003 and an earlier version of excel. Since we have updated to Excel 2007 and in some case updated excel 2003 to Service Pack Level 3 we are getting the following error


The formula you typed contains an error.

For information about fixing common formula problems clcikk help
To get assistance ion entering a function, click ok, then click function on the insert menu
If you are trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (‘)



The error is occurring here where a” –“(Minus) sign precedes the output with text

=FORMULA(TEXT(V_Out_Of_Spec,"0.00") &"-->Out of Spec "&V_MP_Alias,ACTIVE.CELL())

This is the result that the above statement should produce:


-0.07 -->Out of Spec R7BA773FAVD


Anyone have any idea what needs changing to eliminate the error?

Thanks

Mo

 

[ck1999]

Try

="'" & FORMULA(TEXT(V_Out_Of_Spec,"0.00") &"-->Out of Spec "&V_MP_Alias,ACTIVE.CELL())

ck1999

 

[mo2783]

Thanks for the suggestion ck1999 but unfortunatly that solution hasnt worked.

 

[ck1999]

Try removing formula. I get an error with - or not

What are v_out_of_Spect and V_MP_ALias? Ranges, sheets?


=TEXT(V_Out_Of_Spec,"0.00") &"-->Out of Spec "&V_MP_Alias,ACTIVE.CELL()

ck1999

 

[SkipVought]

What in the world is
,Active.Cell()
You can get rid of that.

And I'd put some SPACE between concatenators...

=TEXT(V_Out_Of_Spec,"0.00") & "-->Out of Spec " & V_MP_Alias

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[PHV]

And how is this post related to msaccess ?

 

[mo2783]

Opps sorry didn’t realise I posted to MS Access forum. I do apologise.