convert measurement

R

ramirez

Please , somebody can help me ,when I try use the Convert measurement, I
follow the steps from the Excel 2003 Help:

= convert( 60,"C","F") or =convert(A2,"C","F") I have 60 in A2

always I got this answer :
#NAME?

But when I use Excel 2000, always I got the rigth answer.Where is the
mistake ?
 
S

Steve Huff

Asking your question in an Excel Newsgroup will probably be more helpful for
you. This newsgroup is for Microsoft Access.

--Steve Huff
 
T

Tom Wickerath

Hi Graham,

Yes, it is possible to call Excel worksheet functions in Access.

How to call Excel functions from within Access 2000
http://support.microsoft.com/?id=198571

It sounds like the original poster, Ramirez, was having trouble using this function in Excel
2003. I think he should probably post this question to a newsgroup that deals with Excel issues.
He didn't mention using Access at all.


Tom
________________________________


Ramirez,

Access doesn't have anything like the Excel Convert() function. I'm afraid
the only way to do it is to roll your own. I'm not 100% sure, but I don't
think you can use Excel worksheet functions in Access anyway.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


________________________________


Please , somebody can help me ,when I try use the Convert measurement, I follow the steps from
the Excel 2003 Help:

= convert( 60,"C","F") or =convert(A2,"C","F") I have 60 in A2

always I got this answer :
#NAME?

But when I use Excel 2000, always I got the right answer. Where is the mistake ?
 
Top