I need to remove 0 from the beginning of a code number, but only if the first number is 0

**Jtowers** · 08-12-2014, 06:02 PM

The code numbers are in the format 111-111-111. If the first njumber is a 0 I need to remove it so that the format will be 11-111-111.

Any ideas please?

Thanks

**judgeh59** · 08-12-2014, 06:07 PM

will this work? this assume your data is in col A

Please Login or Register  to view this content.

**Jtowers** · 08-12-2014, 06:24 PM

Fantastic, thanks for the quick answer to my dramas.

**judgeh59** · 08-12-2014, 06:26 PM

not a problem....glad I could help and thanks for the rep points....

I need to remove 0 from the beginning of a code number, but only if the first number is 0

LinkBack

Thread Tools

Rate This Thread

Display

I need to remove 0 from the beginning of a code number, but only if the first number is 0

Re: I need to remove 0 from the beginning of a code number, but only if the first number i

Re: I need to remove 0 from the beginning of a code number, but only if the first number i

Re: I need to remove 0 from the beginning of a code number, but only if the first number i

Thread Information

Users Browsing this Thread

Similar Threads

VBA to remove formulas from specific number columns (number changes each week)

Counting Number of Items Beginning Before and Finishing After a Defined Number

[SOLVED] Zero at the beginning of a number

[SOLVED] [SOLVED] How to display the number zero at the beginning of a number when .

[SOLVED] Change negative sign from end of number to the beginning of the number.

Bookmarks

Bookmarks

Posting Permissions