| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting Lead Zeros
Hi All,
Is there a function in Excel that allows the lead zeros to be removed. The first number in the list has 3 zeros and the final 2 zeros. What would be the best method to remove? 00076245 00076273 00224278 00258071 00250746 I'd appreciate any assistance the group can offer. TIA - H |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| Lead Zeros to Show? | Excel Worksheet Functions | |||
| Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Threaded Mode
