Fractions

  • Thread starter Thread starter whitsl
  • Start date Start date
W

whitsl

I am doing calculations with fractions in Excel and then need to us
these results in Access. Since it looks like I can't display a decima
in fraction terms in Access I need to convert them to a text field i
Excel before exporting. How do I do this?

For example: I am entering 23 1/4 in Excel and then dividing by 2 t
get 11 5/8 or as Excel stores it, 11.625. I need the 11.625 to remai
11 5/8. Can I make this happen? Or does anyone know of a way t
display a fraction in Access in a number field
 
One possibility is a helper column with
=TEXT(A2,# ??/??)

Or, you could wrap the existing formula in it,
TEXT(A2/2, # ??/??)
 
Back
Top