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

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

not sure the "text" answer allows math

why not just format cell as fraction :

Selection.NumberFormat = "# ??/??"

"Bernie Deitrick" wrote:

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

The worksheet function TEXT takes a number and returns a formatted text string.
Selection.Numberformat would work fine, if the variable were actually being stored in the
spreadsheet and not manipulated in VBA.

HTH,
Bernie
MS Excel MVP


"Vacation's Over" wrote in message
...
not sure the "text" answer allows math

why not just format cell as fraction :

Selection.NumberFormat = "# ??/??"

"Bernie Deitrick" wrote:

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

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