I'm new to vba tried to work this issue with an if else but didn't work though So the issue here is the amount of Products with currency as CAD is seen without decimals as you can see in the picture it is supposed to be 6.50 but gets changed to 650 similar with the other product the rest currency amounts have correct decimals so can I create a macro which checks for the currency and accordingly changes the amount cell to shift by 2 decimals
Aucun commentaire:
Enregistrer un commentaire