Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
For case 1 try:
Mid(DATA1, 1, Len(DATA1) -3)
For case 2 try:
Num(PurgeChar(DATA2, Chr(44)))
Saludos.
Hi,
For case 1 try:
Mid(DATA1, 1, Len(DATA1) -3)
For case 2 try:
Num(PurgeChar(DATA2, Chr(44)))
Saludos.
Thanks Federico. I will try this and let you know the results.
Works great. Thanks Federico.