K
Kardock
hi all,
i need to change a value in a cell by removing a dot
for example, i need to convert 2.01 to 201
i can't find the correct formula to achieve my goal. i tried replace and
substitute but it ain't working.
can someone help?
thanks!
i need to change a value in a cell by removing a dot
for example, i need to convert 2.01 to 201
i can't find the correct formula to achieve my goal. i tried replace and
substitute but it ain't working.
can someone help?
thanks!