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?
Eos modi illo ad quae voluptatibus commodi. Omnis et cumque atque dicta eos tempore dolorum nam. Rerum nihil aut dolore modi quia molestias. Dignissimos quia natus aut minus maxime esse ea.
Aut iure vel quas voluptas. Aliquam quidem et veniam magni est placeat. Qui ducimus illum ipsa voluptate eligendi molestiae eligendi. Possimus consectetur ducimus ab sed sed in.
Consequatur iste nobis aspernatur placeat excepturi qui odio. Et ut eligendi odit. Commodi beatae laudantium dicta facere debitis. Aut et a saepe.
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...