PDA

View Full Version : [SOLVED] UDF text case



Zack Barresse
07-12-2004, 09:05 AM
DennisW wrote in another post:


...When You use it (a UDF) for the first time make sure You enter it with UPPERCASE. In that way Excel will "remember" to show the function with UPPERCASE....

Ok, so obviously this explains some things to me. My question is this: If you enter your UDF in lowercase first, is there a way to change it after you've done it one way? Short of deleting the UDF, starting over and re-entering the UDF in the formula bar? :dunno

Just kind of curious. :)

Juan Pablo Gonz?lez
07-12-2004, 01:01 PM
Close Excel and open again.... (having deleted the formula in Excel), if I remember correctly, that shall do it for you.

Zack Barresse
07-12-2004, 01:37 PM
Thanks Juan, I'll give it a go! :)