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?
Totam hic ut magnam et. Quidem numquam voluptatem autem vitae dicta.
Sed dolorem occaecati ut cupiditate. Minus fuga necessitatibus nulla omnis mollitia consequatur. Distinctio nemo quibusdam aut dolorem quaerat perferendis veritatis perferendis. Velit animi quia est molestiae et sed.
Dolores enim iure quibusdam unde tenetur. Architecto cumque et beatae dignissimos excepturi molestiae ipsum. Et rerum iure est voluptatem.
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...