RE: Remove trailing zeros
Hello Carrot,
Thank you for posting your questions!
As we don't support Macros in GP Support, i don't have a lot of info that i can provide. However, the Community might.
With your Excel file, are you using decimal places or just whole numbers? With GP, when we manually type a value it, it always starts at the last decimal place. If your excel file is using decimal places, try formatting the cell to be a whole number.
Example:
12345.67 would be 1234567.
Test your macro and see if that now comes into GP as 12345.67.
If this works, for the ones that do not have a decimal places, you would need to have those cells include the .00 and the ones with cents be 123456.
If this does not help, hopefully the community can provide insight if they have experienced this in the past.
I hope this helps!
Microsoft Support Engineer | Brandon Jarrett