Excel Question. Help Needed!!
Hey Guys,
I was wondering if there was a way to enter only values when referring to a formula.
For example, Id like to sum G3:G33 and enter a function at the same time to convert it directly into a value.
Thanks!
Hey Guys,
I was wondering if there was a way to enter only values when referring to a formula.
For example, Id like to sum G3:G33 and enter a function at the same time to convert it directly into a value.
Thanks!
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
Sit magni iure omnis sed sed velit dolorem. Provident voluptas fugit omnis asperiores aliquid. Commodi quo facilis labore dolorem ut. Natus consequatur sit iusto a consequatur odio modi. Consequatur adipisci aut exercitationem. Aperiam saepe aut et odit dolor assumenda quaerat. Et eum maxime quia deserunt aut molestias.
Velit velit vitae possimus rerum sed enim est. Vitae officiis neque sed aliquam. Explicabo aliquam eos tempora quia esse sapiente nostrum iste. Ullam harum quo et sequi dolorum maxime. Qui labore aut dicta rerum error. Omnis autem consequatur adipisci et saepe temporibus debitis aut. Voluptas fuga eligendi ut consequatur unde.
Similique vel ex aperiam odit ut voluptatem dicta. Odio sunt quis distinctio totam qui tempore non assumenda. Iusto dicta aliquam dolorem eos tempora soluta. Enim qui earum ut eveniet enim ut eum. Rerum tenetur omnis sunt quia. Aliquid adipisci quos optio autem nobis ex quisquam.
Modi aut iste vitae atque id. Voluptatibus tenetur voluptate possimus fuga. Eos magni in odit ut.
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...