Using Excel 2010, I'd like to convert all of the values in a workbook from formula based to plain numerical values all at once...is this possible?
For example table 1, cell A1 is "=3*2". Table 2 cell A1 is "=2+1".
I'd like to run a conversion and have table 1, cell A1 be "6", and table 2 A1 be "3".
Is there a way to do this without doing a table by table cut and repaste as values?
Thanks in advance...
I don't know your purpose on doing this but use a BACKUP but here non VBA approach
select all sheet tabs by
1. clicking the first tab then hold down the shift key select the last tab
2. click the button beside the column header A "All Cells option"
3. right click you mouse select copy then right click again select paste values
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks