Forum Discussion
cells with data copied from html the numbers are not able to do calculations
Simple task at hand, wanted a percentage on category of deduction from salary gross. Copied and pasted values from online statement. Excel tells me that the cell is wrong data type, so tried to con...
Hi Joel,
Most probably some non-printable characters. Try to apply like
=CLEAN(A1)*1
Your right it was some non printable characters in the field from which my clipboard picked up, thank you.
