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

CALYPSO (cig)	42.205.775	#VALUE!
BRANIFF (cig)	37.668.522	#VALUE!
COBURN (cig)	31.639.091	#VALUE!
CALYPSO	31.046.199	#VALUE!
FARIAS (cig)	25.248.766	#VALUE!
AMIGOS (cig)	19.739.506	#VALUE!
ROLL'S (cig)	18.985.823	#VALUE!
DUCADOS (cig)	17.593.681	#VALUE!
SILVERADO (cig)	16.615.632	#VALUE!
FARIAS	16.316.422	#VALUE!

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

 

[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