I'm trying to format a textbox to show fractions using the following
- Code: Select all
UserForm1(Box_Name) = Format(UserForm1(Box_Name), "# ??/??")
When I run it, it show something like 100 ??/?? instead of 99 3/4 (it rounds up)
I've used "(000) 000-0000" to format phone numbers, "MM/DD/YYYY" for dates, "0.00" for numbers with 2 decimals, they all work. Does anyone know what's wrong with the fraction?
Thanks