I was wondering if there is anyone out there that can help me convert a copied text number into a numerical value in excel. I have attached the file if you are interested.
I have tried for a awhile and have not accomplished anything on it.
Thanks,
J
a b c
Amount
−16.00 −16.00 #VALUE! NEEDS TO BE CONVERTED TO A NUMBER
−14.06 −14.06
−64.99 −64.99
−23.60 −23.60
I have tried =-1*a1 result would be #value
I aslo tried 1 in a cell then copy paste special after highlighting column A picking multiply and still nothing.
I tried to upload the file but its not working so here is the mock up of it.
Bookmarks