Cell format is not changed, it is some how passive

Hello Everyone,

I have copied a page from my system, and pasted it to excel 2007, the problem is I am not able to auto sum the numbers.
When I want to change the format of that cell, it is not editable. Weather I change it into currency or date, it remains same.
Any one have idea about this?? Please help me.

Thank you.

Hello JosephP,

I have already tried it and it does not work, Thank you for your response, if you have any other solution please reply.

Thank you.

Originally Posted by JosephP

can you post a sample-perhaps you have spaces or hidden characters in the data

hello JosephP,

I have attached the sample data.

Thanks

Originally Posted by vlady

in a vacant cell

=SUBSTITUTE(C2,CHAR(160),"")
now copy ->paste values -> those returned values to the original column C then change the format.

Hello vlady,
I am sorry i can't get you, Please elaborate me the process. I am confused.
Thanks

Originally Posted by JosephP

you can also use find and replace:

select the data
Ctrl+h
click in the find box, hold alt key and type 0160 on the number keypad
leave the replace box empty and press replace all button

Hello JosephP,

When I hold alt key and try to type 0160 I can not type anything.

Thanks

Originally Posted by JosephP

when you release the alt key you should get a character but you have to type on the number keypad on the right of the keyboard

Hi,

I don't have number keypad in my laptop, is there any other option??

Thank you.