Excel: Using fractions and convert to decimals ?

8 months ago by tdTrX to c/microsoft

  1. How to not auto similify 3/6 to 1/2

  2. Convert to decimal in similified format w/ recurring bar

Pic Left side is manual text right is formula

freshcow 1 point 8 months ago

Right click the cells, there should be an option for "Format". Then look for "Number" and there should be options for decimals, fractions, etc. You might also try throwing an equal sign in front of your fraction cells to be sure it's evaluating it as a number.

path: 0 21839317, hotness: undefined, score: 1, children: 0
microsoft
microsoft

@lemmy.world

login for more options
982
36
108

go to feed...