| 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!!!! |
| 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) | |||
Threaded Mode
