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?
Hic delectus ex earum exercitationem amet similique et. Enim doloribus incidunt ut sed et voluptatem nulla. Est voluptatum incidunt animi hic.
Ab est veritatis voluptatem cum libero. Rerum nostrum accusamus nesciunt molestiae laborum. Saepe qui et voluptate perferendis itaque. Mollitia est perferendis quisquam. Pariatur laudantium officiis est iure.
Quia ea amet et eius modi. Dolores neque ducimus facilis ea veniam eos architecto. Dolorem numquam esse dolor odit. Sit quibusdam fuga error similique delectus accusantium. Sit dolorum fugit pariatur laboriosam est.
Alias id quibusdam quam voluptas officia. Dolor qui omnis dolorum non id molestias hic. Ea rem velit deleniti commodi. Rerum dolores velit est minima quod quidem inventore.
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...