Change cell format from "general" to "number"

[ROLAND.]

I imported a file in excel but the amounts appear as general and not as a number.
Tried already to change the cell format without succes.
Initially formated other cells and copied the data to that cell as "value" but also without succes.
Is there a way to change the format of a cell on another way so I can use the data as numbers or do I have to retyp the data.

thx
Roland

 

[Stormseed]

Assuming that your data starts in cell A1, in the adjacent column in cell B1, enter the formula:

=A1+0 and copy down till the end of your data. Copy the whole range from B1 and paste as values. You can delete column A and now you can treat column B as column A.

You have numbers now

 

[Willem!]

Reformatting (rightmouseclick -> format cells -> (...) ) should do the trick.

Do you have spaces or other characters in de cells?

 

[Andrew Poulsom]

If the entries are text strings that look like numbers, you should be able to convert them by choosing Data|Text To Columns and clicking Finish.

 

[ROLAND.]

Thanks to all. Problem solved

Roland

 

[Stormseed]

Thanks to all. Problem solved

Roland

How ? When ? Where ? Really............. ?

My friend, do you care to drop a couple of words about the way of your problem getting solved ?

 

[ROLAND.]

Saw that the "numbers" were written like this : 6,191,45
Reformatted again the cells and replaced the first comma by
a dot : 6.191,45.
Everything is known as a "number" now.

Roland