Thanks! That is exactly what I needed.

Mike

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Mike,

Apparantly, Format doesn't do fractions, but this does:

Application.Text(1.5, "# ??/??")

HTH,
Bernie
MS Excel MVP


"Mike Weaver" wrote in message
...
why doesn't this work?

format(1.5,"0 ??/??")

should return a string "1 1/2", it seems. Instead, it returns "2 ??/??"

What am I missing?

Thanks in advance