UDFs called from the worksheet can't change cell format (just as with
built-in functions).

To change format, you'd need to use an event macro instead.

In article ,
scott56hannah wrote:

can
anyone suggest where I am going wrong ?