Cookie Policy: This web site uses cookies. By using this site you agree to our cookie policy.
Disclaimer: By posting on this web site it is accepted that you have agreed to the T&C. This is an information forum, and it is just that information, all views are of the individual poster and not that of the site owner. Please DO NOT publish copyrighted material without the owners permission. If you copy news or articles include a link back to the original site. Threads/Posts may be deleted on request. No other links without permission. BEFORE POSTING A QUESTION: Your question has probably been asked before, so please use the SEARCH FUNCTION, as we grow tired of answering the same question again and again. |
Win2Win Racing Club Member
I have some system spreadsheets where i want to adjust the staking now but dont want to affect the data i already have.
Ideally i'd like to convert all the data in each cell from the result of a given formula to just numbers. Then whatever I change wont affect my historical data.
Is there something in excel that can higlight all those cells and convert them to numbers ?
Or heaven forbid have I got to overtype all the data manually ????
tl;dr specialist
Copy the cells in question. Right click -> Paste Special -> Values
Anything that was a formula is now the numerical result of that formula
That what you wanted?
Win2Win Racing Club Member
You are a gentleman :)
P.S. I have to spread some rep around it seems
Win2Win Ltd Administrator
I was going to type that, but new you'd do it! :)
FREE Live Odds Comparison Software
Keith Driscoll - Administrator
Managing Director, Win2Win Limited
Filipino UK Filipino Forum | Win2Win Racing - Free Tips
Win2Win Racing Club Member
Originally Posted by Win2Win
So did I :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Quote Reply