|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 28th, 2010, 04:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! 
|
|
#2
April 28th, 2010, 06:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a bunch of zero's
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!!!!
|
|
#3
April 29th, 2010, 04:59 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a bunch of zero's
"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!!!! Go to excell options the advanced and unclick show zeros
|
|
#4
April 29th, 2010, 05:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a bunch of zero's
What should: 4770:00000000000000 display as??
Go to excell options the advanced and unclick show zeros That wont do anything! -- Regards Dave Hawley www.ozgrid.com "Jeff Brown" wrote in message ... "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!!!! Go to excell options the advanced and unclick show zeros
|
|
#5
April 29th, 2010, 05:24 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a bunch of zero's
4770:00000000000000 is text NOT a dollar value. Select your Column and
Replace : with . and then format the cells how you want them. -- Regards Dave Hawley www.ozgrid.com "ozgrid.com" wrote in message ... What should: 4770:00000000000000 display as?? Go to excell options the advanced and unclick show zeros That wont do anything! -- Regards Dave Hawley www.ozgrid.com "Jeff Brown" wrote in message ... "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!!!! Go to excell options the advanced and unclick show zeros
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
