I have a worksheet where I am getting direct output from STATA that has a weird character format that included " =[ number ]". I put in a new column to strip the characters and leave the numbers. However, the new cell is not recognized as a number, even thought the formatting is turned on to currency. I have to manually click in the cell and then hit enter
to get it to recognize as a number.
A B C
="[-7.734 =RIGHT(A1,LEN(A1)-3) -7.734
But When I go to plot values in Col C, it is not working.
A) Why is this happening? B) Is there a fix for all cells?