Analyzing Financial Statements using Excel - converting Thousands to Millions
Hello,
Sometimes, for ease of understanding, it's required to convert reporting in 000's to 000,000's.
For example, after getting the income statement to Excel, want to report
Revenues 1,778,655
as
Revenues 1,779
Is there an elegant way to do it in Excel?
Of course, I can manually create a similar Sheet where I add "=B2/1000" But it's a lot of work.
Many thanks!
Mark
Well you can always use VBA to define a fucntion that divides everything bby 1000, or a specific range. You can do it either automatic or manual with a shortcut.
You could use alt + esm (paste special) and multiply a certain range or the entire sheet by 1000.
type 1000 into a cell, copy it, then select the values you want changed to millions/thousands and alt e s and either I for divide by 1000 or m for multiply
Thank you, that did the trick.
Quia minus inventore consequuntur tempore est et et. Saepe porro harum repudiandae exercitationem ea voluptates nulla. Et in rerum molestias suscipit doloribus rerum sit. Ipsam saepe eveniet minus.
Voluptas molestiae mollitia aperiam laboriosam commodi inventore id aut. Qui magni enim blanditiis velit voluptas ex rerum. Distinctio minima placeat numquam odio quidem debitis. Dolorem velit et quos et.
Tempora aut vel perferendis quos magnam consectetur et. Eum sunt occaecati praesentium totam suscipit. Assumenda at fugiat id voluptatem est iure. Maiores quibusdam voluptas voluptatem autem ipsa id molestiae consequatur. Quos autem similique sequi omnis praesentium. Necessitatibus qui rerum recusandae.
Perspiciatis nobis inventore eum quae dolores ad. Quasi in vero est aut aut ut. Ut quas et ut. Repellat ullam voluptatem vel officiis vel.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...