Cell apparently not recognized as number; can't perform calculations - #VALUE! output

[bodol]

Hello all:

I have simple statistical data on an excel spreadsheet and when I try to perform calculations it, I get a #VALUE! output.

The cells to which my formula refers are formatted as numbers, so I do not know what may be happening.
It seems as if the data is not recognized as numbers. I have tried to copy and paste as value in another book but the result is the same.

Can anybody please shed light on on this matter?

Thank you,
Bodol

[TABLE="width: 328"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]CALYPSO (cig)[/TD]
[TD]42.205.775[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]BRANIFF (cig)[/TD]
[TD]37.668.522[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]COBURN (cig)[/TD]
[TD]31.639.091[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]CALYPSO[/TD]
[TD]31.046.199[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]FARIAS (cig)[/TD]
[TD]25.248.766[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]AMIGOS (cig)[/TD]
[TD]19.739.506[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]ROLL'S (cig)[/TD]
[TD]18.985.823[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]DUCADOS (cig)[/TD]
[TD]17.593.681[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]SILVERADO (cig)[/TD]
[TD]16.615.632[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]FARIAS[/TD]
[TD]16.316.422[/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

 

[pedro-egoli]

What is the formula

Pedro

 

[bodol]

=cell*100 or =cell+2

The issue may be related to cell formatting, but it is formatted as number

 

[pedro-egoli]

I think the problem is the 2 full stops in your number.

Check out this which is formatted as number

Excel Workbook
	A	B	C
3	CALYPSO (cig)	42.5	4250.00
4	BRANIFF (cig)	37.668.522	#VALUE!
5	COBURN (cig)	31.639.091	#VALUE!
Sheet1

Pedro

 

[bodol]

Thank you, Pedro. It is exactly that. Thanks for noticing!

 

[pedro-egoli]

Glad you got it sorted

Pedro