Removing Format
I received a spreadsheet that contains the following formulas all the way
through it =T("$ 0.00") Because of these formulas I cannot total my columns as requested and I have 588 lines and 11 columns to total and manipulate. How can I remove the formula but still leave the numeric information so I can do my calculations? I've been going into each cell and removing the formula manually which works but is taking an extreme amount of time. There has to be a way to do this as a whole. Thanks, cindy |
Removing Format
Select all of your data.
Copy Paste Special... Select "Values" Click OK HTH, Elkar "Cindy" wrote: I received a spreadsheet that contains the following formulas all the way through it =T("$ 0.00") Because of these formulas I cannot total my columns as requested and I have 588 lines and 11 columns to total and manipulate. How can I remove the formula but still leave the numeric information so I can do my calculations? I've been going into each cell and removing the formula manually which works but is taking an extreme amount of time. There has to be a way to do this as a whole. Thanks, cindy |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com