CODEWITHSUNDEEP
google-sheets
TylerYoc
TylerYoc

Reputation: 75

Convert a fraction to a decimal in Google Sheets

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!

Upvotes: 3

Views: 6947

Answers (1)

nabais
nabais

Reputation: 2037

You can do

=181+7/8

and it will be converted automatically to 181.875

Upvotes: 4

Related Questions