Dividing all constants by 1000 in excel
Hey Monkeys. I noticed that an earlier model that I created had numbers down to the thousands of dollars. It is not optically pleasing and I was wondering if there would be a way to divide all constants by a 1000. I think that should fix the issue.
I learn how little I know everyday. Thank you for the help.
Wow this is new to me
For step 4 I usually do Ctrl + Alt + V to bring up the special paste menu, and press I then Enter for the division option. It's the same menu but I think Microsoft is phasing out the Alt+E access keystrokes in the next update or so.
What liberal slayer will do
you can also just change the cell format
You can change 1000 to 1 via format but the value in the cell is still 1000 unless I'm missing something?
Omnis consectetur nihil aut nemo numquam ipsa. Ea eligendi tenetur nulla non voluptas totam. Laborum in totam cumque. Veritatis necessitatibus delectus ipsa maxime sit.
Consequatur totam fugit laboriosam consequuntur iste velit sit. Sint consequatur dolores debitis rerum corporis consectetur officia. Eum qui iusto asperiores quis perferendis omnis quis alias.
Quia quod voluptatem impedit. Quam iusto aliquid fugit magnam.
Et non delectus officiis. Ut ipsa cum recusandae. Qui veritatis voluptatibus in aliquid.
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...