Hello I am Henk from Amsterdam, NL and I am new to this forum, I hope you can help me with a Macro issue.
For automatic generation of amount from one cell (at another worksheet) to another cell (for a Purchase Order), I use a macro. The only problem is, as soon as there are decimal places of the given amount, Excel automatically starts seeing it as text somehow.
Schermafbeelding 2022-06-23 123418.jpg
This can't be fixed with cell properties either, I've already tried that.
In the code it is about the parts: 'priceExtransport' and 'transportCosts' which should be automatically entered in the worksheet 'Purchase Order' and then rolled out as text instead of amount...
Can you help me make it an automatic amount again, including decimal amounts?
Bookmarks