View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daisy Daisy is offline
external usenet poster
 
Posts: 20
Default How to remove a bunch of zero's

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!!!!