VBA won't format into fraction
Label17.Caption = Application.Text(CDbl(a) - 1 / 8, "# ??/??")
or
Label17.Caption = Application.Text(CDbl(a) - 1 / 8, "# ??/16")
damorrison wrote:
"Label17.Caption = Application.Text(cdbl(TextBox4.Text) - 1 / 8,
"??/??") "..
That doesn't work for me all I get is the number in fractions such as 7
1/8 I get 57/8
--
Dave Peterson
|