I have a whole number and fraction in a cell and I want a whole number and decimal in another cell.
Thank you.
I have a whole number and fraction in a cell and I want a whole number and decimal in another cell.
Thank you.
Last edited by Exceller123; 11-25-2017 at 04:21 PM.
I think this is just a question of formatting, if you have your data in A1, e.g. 1 3/4 and you want to see that as 1.75 in B1 then just use this formula in B1
=A1
and format B1 as number or general
Audere est facere
deleted.....title updated
Last edited by protonLeah; 11-25-2017 at 04:27 PM.
Ben Van Johnson
If your Number is in A1
Then this formula in B1and this formula in C1Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Or perhaps this formula in C1Formula:Please Login or Register to view this content.
Last edited by mehmetcik; 11-25-2017 at 04:06 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks guys its like this: 2 1/2 in cell B15 . in need it to show 2.5 in cell C15 Then i need a formular so that anytime i enter any whole and fraction in that B15 it changes in C15
Thanks.
As per my previous answer, just use = B15 in cell C15 and format C15 as general
Do what DLL proposed usingformatted as NumberFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
thanks Daddylonglegs, ive done as you instructed ,but i want B15 in mixed .whole and fraction ,but will like to C15 in whole and the fraction bit as decimal.
Thanks
Thanks a lot guys and mr moderator, i beg for your pardon. This is resolved now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks