| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I consolidate a bunch of workbooks iinto one? | New Users to Excel | |||
| Need to multiply a bunch of figures | Excel Worksheet Functions | |||
| how do I add a zero in front of a bunch of 4 digit numbers? | Excel Discussion (Misc queries) | |||
| can you sort a bunch of tables going vertically? | Excel Discussion (Misc queries) | |||
| How to generate a bunch of random numbers??? | Excel Discussion (Misc queries) | |||
Hybrid Mode
