I have a excel sheet that has some values something like below.
When I want to get the values by concatenating with a string, points are being erased. The cells format are Number by the way.
If I do
=P3 , it gets me
When I do
="(test '"&P3&"')", it gets me
(test '27655111'). This is not correct. I need the points in the number.
How to do that ?
Thanks in advance