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
|