View Single Post
  #3   Report Post  
Saxman
 
Posts: n/a
Default

Hawk wrote:
How do I display exact fractions instead of being reduced, or changed to a
decimal? I am doing a spreadsheet which has fractions to describe some
things, and Excel either reduces the fraction (ex. 3/6 to 1/2, or 2/2 to 1)
or enters it as a decimal (ex. 2/5 to 0.4). How do I stop it from doing
this? I didn't want to store the fractions as text because i'm not sure if
they will then work in formulas.


Format the column as text.