Sorry - a formula can't directly impose any formatting on the cell which
contains it: it can only return a value.

You'll need to format the cell the usual way.

Tim



"mjones" wrote in message
...
On Feb 13, 12:16 am, "Tim Williams" wrote:
"mjones" wrote in message

...

Yeah, yeah!!! It works!! Yeah, yeah!!
Thanks a bunch!!

At last! Good to hear.

Tim

Hi Tim,

I hate to bug you again, but is there a way to make the GetUnitCost
keep the format of the cell it's in, or at least format it to a number
or currency with 2 decimal places? Some of the costs are coming out
with 4 decimal places.

Thanks again,

Michele