View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
damorrison
 
Posts: n/a
Default VBA won't format into fraction


"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