formatting values to number

[CAAT]

hi

i have been struggling to change the value into number so i can be able to do calculations.
excel does not give me the option to convert to a number.
the values do not even multiply by 1.

please see attached example file

thanks

 

[Somendra Misra]

Hi CAAT,

Your Numbers are text with white space in between Char Code 160. Try below formula in C2 and copy down.

=--SUBSTITUTE(B2,CHAR(160),"")

This will convert the text to numbers and than you can do calculation over them.

One Question: Have you copies these numbers from some website or some other source?

Regards,

 

[CAAT]

Thanks Somendra

I noted it only changes once i save the document. I nearly missed it.

The data is from a proprietary system called Sessions. As I understand it is not a commercial system.

thanks again

Hi CAAT,

Your Numbers are text with white space in between Char Code 160. Try below formula in C2 and copy down.

=--SUBSTITUTE(B2,CHAR(160),"")

This will convert the text to numbers and than you can do calculation over them.

One Question: Have you copies these numbers from some website or some other source?

Regards,

 

[Jamlaudeen]

Hi,

I selected cells like a scattered but its not allowing to copy in excel sheet. I got below error message

"That Command Cannot be used on multiple selection". Can you please help me.

Thanks,
Jamal.S

 

[Somendra Misra]

Hi Jamlaudeen,

Kindly, post a new thread for your problem. Never post your problem in somebody's thread even if the problem is similar too. This brings false result during search operation.

Regards,