Highlight sheet, ctrl+H
Find what : put
:00000000000000

Replace with:do nothing

Ok

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"daisy" wrote:

Can anyone help me with a function that I could apply to my spreadsheet? I
have 10 columns and hundreds of rows coming over from another application and
now that we are in Excel 2007 the $$'s are coming thru with a bunch of
zero's. Here's what it looks like
4770:00000000000000

--
Thank you in advance!!!!