Thread: Removing Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default 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