Convert to Number

[ionelz]

Hi,
This is very ugly data.
When I click in Cell, it say that is Number
When I click in Cell , for many cells, the comma is not there in formula bar, it is shown there
Nothing work so far, not formula , not any conversion I have tried

How to Convert this to Number and show Number as it is "looking" in table ?
Thank you

 

[Joe4]

Firstly, how do you know those values are not already numbers?

If you use the ISNUMBER formula on any of them, what does it return?
i.e.

=ISNUMBER(A2)

If it returns "TRUE", it is already a number.
If it returns "FALSE", they are entered as text.

You can use Text to Columns to convert the values to number. The only caveat is that you can only run Text to Columns on one column at a time.
However, you can use VBA to loop through all the columns to fix them all at once, instead of each column manually.

 

[ionelz]

Firstly, how do you know those values are not already numbers?

If you use the ISNUMBER formula on any of them, what does it return?
i.e.

=ISNUMBER(A2)

If it returns "TRUE", it is already a number.
If it returns "FALSE", they are entered as text.

You can use Text to Columns to convert the values to number. The only caveat is that you can only run Text to Columns on one column at a time.
However, you can use VBA to loop through all the columns to fix them all at once, instead of each column manually.

It is Number, but when I click on cell it say 1307, but is shown 1,307
But I need it as is, meaning 1.307

Than comma "do not exist" it is shown only in celll
Data is conversion from PDF

 

[Joe4]

It sounds like there is a Custom Format applied on the cells.
If you select a cell, and check out the formatting on that cell, what does it show?

Also, what are you Regional Settings for numbers?

Excel Regional Format Settings

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com