| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete zero's from numbers
I need a macro that can delete zero's from a range of cells-the numbers all
start with 0 for example-000222, next cell 000228. I want to delete the zeros but leave the rest of the number. when I write a macro, it replaces the number with a constant rather than leaving the new number in each cell- can anyone help? Thanks, Kathy Beck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete numbers within cells | New Users to Excel | |||
| IF not numbers delete | Excel Discussion (Misc queries) | |||
| How do I delete numbers in a cell | Excel Discussion (Misc queries) | |||
| Delete text while numbers remain intact | Excel Worksheet Functions | |||
| How do I delete 100 account numbers from a spreadsheet colume wer. | Excel Worksheet Functions | |||
Threaded Mode
