10-12-2006, 03:13 PM
Select all the cells, Copy, Paste Special, Values
If you have formatting you want to keep repeat this, but do:
Select all the cells, Copy, Paste Special, Formats
If you have formatting you want to keep repeat this, but do:
Select all the cells, Copy, Paste Special, Formats