numbers conversion

[ncapanzana]

Hello,

I have problems when these example amounts/figures (in A) are shown using a 3rd party application. Instead of showing the up to two decimal places and with comma (,) if necessary, it only show the following (in B)

How can I adjust in the excel in a way that i will get the correct format (in C)?

Ive tried formatting the cells but no luck. It is ok when you format first the column into TXT, then input the nos but what I have is the nos are already in the column which when I format it into text, it will not give me what I expect (C)..

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]256.00[/TD]
[TD]256[/TD]
[TD]256.00[/TD]
[/TR]
[TR]
[TD]1065.50[/TD]
[TD]1065.5[/TD]
[TD]1,065.50[/TD]
[/TR]
[TR]
[TD]0.00[/TD]
[TD]0[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]201.00[/TD]
[TD]201[/TD]
[TD]201.00[/TD]
[/TR]
[TR]
[TD]37.75[/TD]
[TD]37.75[/TD]
[TD]37.75[/TD]
[/TR]
[TR]
[TD]100,030.00[/TD]
[TD]100030[/TD]
[TD]100,030.00[/TD]
[/TR]
</tbody>[/TABLE]


Thanks
Nino

 

[Special-K99]

Don't format as text, format the cells as Number with 2 decimal places and tick the box that says "use 1000 separator (,)"

 

[ncapanzana]

when I checked the format, it is already in number.. i can use 1000 seperator (,), but when i use the 3rd party program, it doesnt include those ending with 00 after the decimal.

eg

200.00 --> 200
378.00 --> 387