how to correct wrong numbers ?

[pooja2010]

Hi,

I have numbers in my excel column showing as follows:

27.457

41.051

39.951

27.824

<colgroup><col></colgroup><tbody>
</tbody>

I know they are not correct and shows a 1000 separator instead of being a double digit number "27,45" with 2 decimals. I am not able to change that somehow.. Can anyone help me know how to correct them. So the correct numbers instead of the above should be as follows (2 digit main number, and 2 digit decimals)

27,46
41,05
39,95
27,82

Thanks in advance..

 

[jayanthiv]

Right- click on the data.
Choose 'format cells'.
In the pop-up dialog box that comes up, click on number tab -> choose 'Number' under category
Make sure 'Decimal places' is set to 2 on the right side.
Click OK.

 

[pooja2010]

I have already tried that.. But I don't know for what reason it is not working. Instead it gives me

27.457,00

41.051,00

39.951,00

27.824,00

<colgroup><col></colgroup><tbody>
</tbody>

Do you have any other idea ?

 

[sallinspark]

What are the Decimal Separator and Thousands Separator settings in your version of Excel?
If you look under File > Options > Advanced you should see "Use System Separators" checkbox ticked and under that it will tell you the current setting for Decimal and Thousands.

Looks to be that excel is using "." as the decimal separator and you want it to be ",".

 

[pooja2010]

I just checked that.. Excel is using "," as decimal separator and "." as thousands separator.. Its correct what i want.. But still i don't know y i don't get the right numbers.

 

[ChrisR]

Hi,

It could be a windows setting over-riding it............

Try

Control Panel --> Regional Settings -->Regional Options --> Customise

 

[sallinspark]

When you look at a cell, is the data right justified or left justified? Also, is the data being imported from another source?

 

[jayanthiv]

I just checked that.. Excel is using "," as decimal separator and "." as thousands separator.. Its correct what i want.. But still i don't know y i don't get the right numbers.

Did you mean "." as decimal separator and "," as thousand separator?

 

[pooja2010]

@Jayanthiv.. no, i meant the other way round.. This has to do with regional settings, where in the opposite is used in the netherlands where i am right now. so the decimal is "," and thousand separator is "."

@sallinspark.. the data is displayed on the right. The data is from a different source.. but i guess it is from a different version of excel. i am not sure.

@Chris, the regional setting there is mentioned netherlands.. is there anything i can customize there ?

 

[jayanthiv]

@Jayanthiv.. no, i meant the other way round.. This has to do with regional settings, where in the opposite is used in the netherlands where i am right now. so the decimal is "," and thousand separator is "."

@sallinspark.. the data is displayed on the right. The data is from a different source.. but i guess it is from a different version of excel. i am not sure.

@Chris, the regional setting there is mentioned netherlands.. is there anything i can customize there ?

Use 'Text to Columns' in the Data tab to reset the cell format to 'General'. ( You may have to deselect the "System Separator" in the Files->Options-> Advanced). You should then be able to chnage it to the format you need ( i.e 2 digits with 2 decimals).