# Change cell format from "general" to "number"

#### ROLAND.

##### New Member
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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### Stormseed

##### Banned
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!

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

Do you have spaces or other characters in de cells?

#### Andrew Poulsom

##### MrExcel MVP
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.

##### New Member
Thanks to all. Problem solved

Roland

#### Stormseed

##### Banned
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.

##### New Member
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

Replies
8
Views
94
Replies
3
Views
532
Replies
3
Views
346
Replies
9
Views
206
Replies
3
Views
530

1,191,204
Messages
5,985,261
Members
439,953
Latest member
suchitha

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back