Remove Three Zeros and Remove the Comma Separator

[pandreozzi]

I have two questions for those who are developers as I am not.

First:

I have a series of numbers: These are just examples each are independent and being read from an excel spreadsheet.

80000

100000

20000

I want to remove the three (3) trailing zeros to have them display

10

100

20

Second:

I also have a series of numbers as follows.

080,000

0041,211

0002,738

I need to remove the leading zeros and the comma separator

Once done I am going to calculate the two numbers to get an average so a/b=c

Any suggestions is well appreciated

[fvelascog72 · Accepted solution]

Hi,

For case 1 try:

Mid(DATA1, 1, Len(DATA1) -3)

For case 2 try:

Num(PurgeChar(DATA2, Chr(44)))

Saludos.

[pandreozzi]

Thanks Federico. I will try this and let you know the results.

[pandreozzi]

Works great. Thanks Federico.