Trending Content - Investment Banking Forum
| +203 | Return Rates For Interns Are Falling? | 83 | 2h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 1d |
| +102 | I am a drunk MD AMA | 38 | 4h |
| +76 | London IB BB is a challenge | 41 | 22h |
| +75 | KISSED MY VP… HELP!!! | 14 | 9h |
| +63 | VP Lifestyle at Top BB Coverage Groups | 40 | 12h |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 3d |
| +49 | SharePoint makes IB hours HELL | 15 | 3d |
| +48 | UBS Offer Day | 18 | 10h |
| +44 | momentum of Rx groups | 16 | 17h |
Career Resources
it's circular logic . . . so you probably can't because you need a formula to feed the range, hence it won't be a value.
don't know if there's a better way or if this is even what you mean, but type in the formula as usual, then hit F9 before you hit enter, Excel should calculate the formula first and then when you hit enter, enter just the result rather than the actual formula For your example, try typing =sum(G3:G33) then hit F9 then hit enter should work
select a cell... then hit F2 to edit formula then hit F9 to convert to values
Paste Values... copy cell then Alt+ESV to paste values
Or VBA for alot of cells without Alt+ESV Sub ConvertToVal() Dim bcell as range For each bcell in selection bcell.formular1c1=bcell.value next bcell End Sub
if you assign that shortcut key like ctrl+q or something, it is pretty quick and useful
Enim autem sed dicta neque error. Iusto rerum praesentium dolores dolor error. Aut itaque dignissimos autem quo illum aperiam. Officia voluptatem aliquam fuga vitae doloremque. Laborum porro dolorem voluptatem et qui voluptate. Reiciendis alias aliquid illum dolore.
Voluptatem saepe rerum culpa aut. Enim recusandae eius blanditiis tenetur sed veniam quidem. Nobis laboriosam voluptas 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...