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