Hi,
In a workbook some of the numbers I have to use are in format: 12,50. How can I modify the formula so it transforms it to 12.50 (so that excel knows this is a number)? I am getting the values with:
and all the values are with "," instead of "."![]()
=VLOOKUP(F1,Sheet1!$A:$B,2,0)
Please check the example attached.
Thank You!
Bookmarks