Excel formatted as number but left aligned

[mellin8]

I have a list of product ID (consist of all numbers) generated from another system.However these numbers are already in format number but left aligned.
I need them to be number format as I am using this file for another system.
Any advice?
Thank so much.

 

[Legacy 386498]

If I understand your problem, use the Value function. So if your list starts in cell A1, in cell B1 (or wherever you want it) =Value(A1).

 

[shg]

Assuming there are no spurious characters, select the column, Data > Text to columns, Finish.

 

[mellin8]

If I understand your problem, use the Value function. So if your list starts in cell A1, in cell B1 (or wherever you want it) =Value(A1).

Thanks, I tried but why the number is still left-aligned.

 

[mellin8]

Assuming there are no spurious characters, select the column, Data > Text to columns, Finish.

Thanks, I tried this method as well, but the number is still left-aligned.

 

[Michael M]

Assuming the data is in col "A", in another column type =LEN(A2)....or whatever the offending cell is and count the characters...'I'm guessing you have a Char(160) or similar in with the numbers....especially if it's imported data !!
you could try, in another column

=SUBSTITUTE(A2,CHAR(160),"")

and see if that helps

 

[sandy666]

Select this column then from the ribbon choose: Clear - Clear Formats
then use number format

 

[mellin8]

Select this column then from the ribbon choose: Clear - Clear Formats
then use number format

Yes, it works, Thanks all :D

 

[sandy666]

You are welcome
Have a nice day