Returned values from UDFs don't respect the format style of the cell

Please attach an Excel sample and show your UDF's code

Functions don't return data types. They return numbers or text (or boolean). The cell then takes that number and applies the number format indicated by the user.

What is the code for your UDF?
Or ... Fluff's request for a sample workbook is even better, and it would include the code.

Is there a way that I can ensure the function respects the format of the cell?

Make sure that the UDF is not returning a "number as text". For example, this

Please Login or Register  to view this content.

returns a number as text, and text does not respond to number formatting.

So, what about the code and the file ...!

mikerickson, thank you for your reply. What you are saying is what I expect to happen, I want the UDF to return the value and then for the cell to handle formatting separately (either by the user deciding the format, or having a sub preset the format). In practice this doesn't seem to be happening as the function is ignoring any custom formats.

The first thing I notice in your UDF is that you are assigning the value "123.456" as the result. Note that this is a text string, which is often vastly different from the number 123.456 (no quotation marks). This is exactly what I mentioned in my post -- make sure your UDF is returning actual numbers when it should. change the assignment statement in your example to returnValue=123.456 Obviously your posted code is "dummy" code, so you will need to go through your real code to see how you might inadvertently be returning numbers as text strings that are not really numbers.