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