Ladkisson

asked on

# How to trim zeros infront of a number

Hi,

I have data downloaded from a system and the format requires the numbers to have zeros in front of them. For example: instead of 20 it has 0020, instead of 100 it has 0100 and so on. The data is not in any particular order.

What formula will eliminate these zeros?

Thx!

I have data downloaded from a system and the format requires the numbers to have zeros in front of them. For example: instead of 20 it has 0020, instead of 100 it has 0100 and so on. The data is not in any particular order.

What formula will eliminate these zeros?

Thx!

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.