So I have 2 tables one in millions and the other in thousands, the millions numbers look like this 4459 and 255, I want to make them 4459000000 and 255000000.
Same with table with thousands, where it has numbers like 304253 and 13641, I want to make them into 304253000 and 13641000, can someone tell me the formatting code to use for them?
Hi,
here you could find some ideas and a file to download.
http://chandoo.org/wp/2012/01/31/cus...y-power-of-10/
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Try in Custom Format.
#,##"000,000"
#,##"000"
Edit:
Hi Stefano. It's a long time that i didn't show you here.Glad to see you again here.
Last edited by Fotis1991; 10-09-2013 at 04:49 AM. Reason: Edit:
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Wow that helped quite a bit!
One issue that I have is that the numbers on the table have changed but the cell value is still the same.
It shows 4459000000 on the table but when I select it I can still see 4459 in the formula bar.
Is it actually possible for me to make the cell value the same as the format value....? (I'm so lost when it comes to excel T_T)
Ok. Sorry. I missed your post#4.
What we do using Custom Format is to make your numbers to look like thousands or millions.
We don't convert these.
Not sure that i understand what you mean. Would you like to upload a small example sheet with some examples of what are you trying to archieve?..Is it actually possible for me to make the cell value the same as the format value....? (I'm so lost when it comes to excel T_T)
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I'll try to explain more as well, I have three tables in a sheet both are in short form of their numbers, one is in millions and one is in thousands, I have to use figures from these tables in formulas and only the full form of their numbers will give me a proper answer.
Edit: that blue column at the far right side are the values I'm trying to calculate for.
Last edited by Ninjja; 10-09-2013 at 05:50 AM.
Perhaps you could use in any calculation that you do regarding your first table something like this in T4, for example.
=H32/B47*1000000
OR
You can use some helpers and hidden columns. In this you'll multiply the numbers of your first table by(*) 1000000 and then to do all your calculations using that hidden columns.
That makes sense for formulas that involve the one table, what I'm struggling with is stuff like the return on equity where it's = net income / shareholders equity (or H32/B46), where it grabs numbers from 2 tables to use
But your numbers in your second table(that includes H32) is in thousands. No need of converting here. If were like table 1, you could use something like..
=H32*100000/B46*1000000
The numbers in the orange table are in the millions and the ones in the green and purple are in the thousands, My ROE should be 260234/3460000000 = 0.0752121387
If I use =H32*100000/B46*1000000 I get 7521213872832.37
You get this result just using
=(H32/B46)/1000
Of course anyone that have a better approch is welcoming here!
That works! Thanks a bunch buddy!
I also found this string while I was tinkering with the formula bar
=(H32*1000)/(B46*1000000)
It works too! Thank you very much kind sir!
You are welcome and thanks for the feed back.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks