Convert a fraction to a decimal in Google Sheets

Viewed 4542

I am attempting to type a fraction into a cell in Google Sheets and have it convert to a decimal (like Excel does by default)

For example, if I enter "181 7/8" I would like to convert to "181.875" when I hit enter.

I cannot find anything about this on the webs. Please help!

1 Answers

You can do

=181+7/8

and it will be converted automatically to 181.875

Related