Forum Discussion
1039544
Jul 27, 2024Copper Contributor
VLOOKUP
Hi there, I was making an automated nutrition plan and I've been struggling with this one problem for a long time now... Whenever I use VLOOKUP and try to multiply it with another cell, it gi...
- Jul 27, 2024
1039544 Since you are using Dutch Excel, you need to use commas for the decimal indicator. Now, all your 'numbers' ar texts except the few "0,0" that are right-aligned and visible in the screenshot . Use Find & Replace (ctrl-H) and replace all dots (period) with commas and that should resolve the issue.
Riny_van_Eekelen
Jul 27, 2024Platinum Contributor
1039544 Since you are using Dutch Excel, you need to use commas for the decimal indicator. Now, all your 'numbers' ar texts except the few "0,0" that are right-aligned and visible in the screenshot . Use Find & Replace (ctrl-H) and replace all dots (period) with commas and that should resolve the issue.
GrettaFrederick
Aug 07, 2024Copper Contributor
Thank you so much for help.