View Single Post
  #3   Report Post  
Alan
 
Posts: n/a
Default

"dan" wrote in message
...

When I updated to 2003 three some of my spreadsheets not longer

worked
because the CONVERT function is no longer available. Does anybody
know why it was removed??


Hi Dan,

It is a custom function that is supplied via an add-in.

As a general rule, I would suggest that you avoid using functions from
add-ins since, as you have discovered, they only work if the user has
that particular add-in available. If you need to use a custom
function, you could include it with the workbook, but that then means
the user gets a 'macro' warning when opening the workbook (if they
have their settings to warn).

IMHO is it just better to avoid using UDFs and functions from add-ins
if at all possible.

Not always easy I grant you!

Alan.