# Fraction not turning into decimal

1. ## Fraction not turning into decimal

I am copying and pasting race results into a excel spreadsheet and having a problem with prices. For the main part it is fine because I can format the columns so that 9/4 will turn into 2.25 but when it is 9/4F, I am struggling to turn the 9/4 into 2.25 having removed the F using =LEFT(A1,LEN(A1)-1). If I format the cell with this formula in to a number format then it still shows 9/4 not 2.25.

2. ## Re: Fraction not turning into decimal

There's probably a more efficient way but at this time of night...

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Fraction not turning into decimal

Thank you so much!

4. ## Re: Fraction not turning into decimal

Originally Posted by JHOWARTH31
Thank you so much!
My pleasure.

5. ## Re: Fraction not turning into decimal

You can try:

=--("0 "&LEFT(A1,LEN(A1)-1))

Or full formula:

=IFERROR(--("0 "&A1),--("0 "&LEFT(A1,LEN(A1)-1)))

6. ## Re: Fraction not turning into decimal

Another way:

 A B C 1 9/4F 2.25 B1: =--("0 " & LEFT(A1, LEN(A1) - 1))

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1