Just to add (from help):
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using Add-Ins on the Tools menu.
-------

so convert is provided by the Addin Analysis Toolpak (shipped with Excel,
but not necessarily installed or selected in tools=Addins)


--
Regards,
Tom Ogilvy

"Niek Otten" wrote in message
...
=CONVERT(A1,"C","F")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sam" wrote in message
...
I am trying to create a custom function in Excel XP to automatically
convert
temperatures from Farenheit to Celsius and vice versa.