Hello.
Im very new at using exel and i dont have much knowledge.Im doing a project.
So for example in A1 its written 13.6B (B stands for bilion) so i need a formula which will convert 13.6B into 13600000000 in the B1.
I failed to figure it out myself so could someone please help me.
Thank you for taking your time to read my post.
This should work.
Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
No sorry that doesnt solve my problem,im geting an error with your formula.
You may have to replace the comma with a semi-colon.
=LEFT(A2;LEN(A2)-1)*1000000000
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi,
Do you have have any leading or trailing spaces? e.g. "13.6B "
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks a lot evryone for your time,it worked.I was a big help!
Keep up the good work!!
Last edited by Vjosa; 06-01-2015 at 08:03 PM.
Did you try post #4 & how about #5? if there is a space maybe the trim will do.
=LEFT(TRIM(A2),LEN(TRIM(A2))-1)*1000000000 base on post#4
Is it displaying 1.36E+10 --- if so adjust the column width
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks