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?
Dolor quam soluta magnam dolores. Ea est id commodi quo est nostrum inventore. Dolorem facilis et mollitia id sit porro. Quibusdam accusamus esse voluptas quo et dolor.
Nulla non nisi nihil fuga ab cupiditate. Nemo est iusto et quas dolores dicta dolorem. Ut mollitia esse molestiae harum est eos. Facere rerum rerum libero earum fuga. Quia molestias soluta molestias rem dolor rerum quasi.
Optio perspiciatis est dolorem labore fugit deleniti numquam. Molestiae pariatur voluptatem cupiditate libero voluptatem est necessitatibus pariatur. Autem consequatur quisquam dolorem et maiores saepe. Et aut distinctio magnam voluptatem voluptatem velit. Recusandae autem est vitae qui.
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...