Paul_Hossler
05-14-2018, 07:38 AM
This is an extract of larger project
Simplified it to just experiment in immediate window to try and get it to work
I put 123.456 in A1, and formatted it using the Format, Number, Fraction, As Sixteenths
Displays correctly on worksheet as 123 7/16
When I try to Format() it internally as part of a string, I get 123 ??/16
?activecell.NumberFormat
# ??/16
?format(123.456, "# ??/16")
123 ??/16
Does Format() work with fraction formats?
Simplified it to just experiment in immediate window to try and get it to work
I put 123.456 in A1, and formatted it using the Format, Number, Fraction, As Sixteenths
Displays correctly on worksheet as 123 7/16
When I try to Format() it internally as part of a string, I get 123 ??/16
?activecell.NumberFormat
# ??/16
?format(123.456, "# ??/16")
123 ??/16
Does Format() work with fraction formats?