How to remove a bunch of zero's

D

daisy

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
 
E

Eva

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

Replace with:do nothing

Ok

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

Greatly appreciated

Eva
 
J

Jeff Brown

daisy said:
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
Click to expand...


Go to excell options the advanced and unclick show zeros
 
O

ozgrid.com

What should: 4770:00000000000000 display as??

RE: Go to excell options the advanced and unclick show zeros

That wont do anything!
 
O

ozgrid.com

4770:00000000000000 is text NOT a dollar value. Select your Column and
Replace : with . and then format the cells how you want them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove a combination of letters and special characters 2
How to sum the number of times answered in a single column with b. 1
How to remove a bracket that is itallicised for an entire document 1
Dealing with a Pivot Table (when I don't want to) 0
Need Help with a VBA subroutine 0
Is it possible to edit colours already saved as part of a custom theme? 0
Function to populate cells?? 3
How to get the leading zero's added in a document 3

Top