Trending Content - Investment Banking Forum
| +268 | UBS Layoffs (October 2026) | 84 | 22m |
| +121 | Do people still want to go PE? | 36 | 17h |
| +98 | UBS Tech layoff | 37 | 10m |
| +36 | Lazard hirevue | 11 | 2d |
| +36 | What Differentiates the Best Analysts as AI Improves? | 9 | 2d |
| +33 | How do YOU manage networking requests? | 7 | 3h |
| +31 | Quitting After First 4 months | 10 | 1d |
| +27 | MBB Pay Raises | 12 | 41m |
| +25 | Cornell Club T10 Rankings (UPDATED 10/2026) | 16 | 12h |
| +25 | Are target prospects getting dumber? | 11 | 14h |
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
Expedita laudantium vitae unde ea in. Architecto magni doloremque quo tempora. Maiores et hic eos. Occaecati minus cumque non iusto. Est consequatur vel esse itaque temporibus magnam quo. Officiis laboriosam rerum neque et neque.
Dolor ut saepe quos in doloribus et laborum. Quisquam officia voluptatem molestiae.
Voluptas consequatur ad et voluptas. Dolorem mollitia necessitatibus voluptatem et ducimus dolor quas. Aut et necessitatibus eum nihil. Sunt numquam sit quia culpa. Ex nesciunt quas tenetur fuga saepe quia.
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...