Is there anything I can do with the negatives that show up as 456.78- ?

"Ron Coderre" wrote:

Try this:

Select a blank cell
EditCopy

Select the range of numbers
EditPaste Special
Check: Add
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Darlene" wrote:

I am using Excel 2000 and have received a large data file downloaded from a
mainframe system. Is there a way to easily convert the numbers stored as
text back to numbers so I can total them?