when I copy a number from cell A2 "1.1.1" and past it to B2 it shows as "1.1.1" which is good, but the cell next to it that has a function that is looking for a number wont work until I retype the number in the copied to cell. I've checked the type cell to number and have tried all the paste as types. what is wrong