Forum Discussion
imported data format in Excel different and not adjustable
Hello all I have a table imported into Excel (see attachment). On some cells I got the message with the known green triangle of how to transform them (number, text etc.). I changed them to numbers b...
Hi Richard,
You still have apostrophe inside (thus text string). You may use
=SUBSTITUTE(SUBSTITUTE(C2,"'",""),"CHF","")
to convert (first yellow column)
Hello Sergei
Sorry I was not able to change it. I get error massages with this formula. How can I see it is still a text cell and is there a other way of getting this changed into numbers?
Regards
Richard
Hi Richard - could you attach sample file with the formula where it doesn't work? In my file which is in previous post formula works.
