UDF to return as text

[Fan924]

This UDF returns a Hex number. I would like it to change the cell
format to text. Thanks,

Public Function DecToHex(DecNumber As Variant) As String
DecToHex = Right("0" & Hex(DecNumber), 2)
End Function

 

[Ron Rosenfeld]

This UDF returns a Hex number. I would like it to change the cell
format to text. Thanks,

Public Function DecToHex(DecNumber As Variant) As String
DecToHex = Right("0" & Hex(DecNumber), 2)
End Function

A Function can only return a value. It cannot change the environment.
--ron

 

[Fan924]

A Function can only return a value.  It cannot change the environment.

--ron

Ok, thanks. That explains why nothing I tried worked.

 

[ryguy7272]

Maybe this:
=TEXT(A1, "0")

HTH,
Ryan---

 

[Ron Rosenfeld]

Ok, thanks. That explains why nothing I tried worked.

Perhaps with more information, someone might devise a solution to your problem.
--ron