I made a calendar file on Excel at a computer with Windows XP and a version
of Excel earlier than the 2007 version designed for use with windows vista.
When I transferred the file to my home computer which uses these later
Microsoft applications (Vista and Office 2007), a user function I had made to
display the ordinal form of cardinal numbers gave me the useless and
ubiquitous error of #NAME? in every cell I had used it. The function is...

Function Ordinal(CardNum) As String
OrdEnd = "th": CardNum = Int(CardNum)
If CardNum Mod 10 = 1 Then OrdEnd = "st"
If CardNum Mod 10 = 2 Then OrdEnd = "nd"
If CardNum Mod 10 = 3 Then OrdEnd = "rd"
Teens = CardNum Mod 100
If Teens 10 And Teens < 14 Then OrdEnd = "th"
Ordinal = Format(CardNum) + OrdEnd
End Function

This function works just fine in its file of origin. But the file I brought
home fails to, well, function with the very same macro procedure. I am quite
perturbed. Help!
--
If it ain''t broke, don''t fix it!