Hello Excel experts:

I have one doubt in this following sheet:

1997
EU (27 countries) 100
EU (25 countries) 104,9
EU (15 countries) 115,5
Euro area 115,9
Euro area (15 countries) 0
Euro area (13 countries) 114,4
Euro area (12 countries) 114,7
Belgium 125,9
Bulgaria 26,5
Czech Republic 73,1
Denmark 133,5
Germany 124,6
Estonia 41,9
Ireland 115,1

If I change point for comma format in cells just change in several ones but
not in all of them could you tell me please?

thanks

Do the cells that don't change contain text instead of numbers? Try
=ISTEXT(A1) with the A1 being changed to the appropriate cell reference.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"MAXRAF80" wrote in message
...
Hello Excel experts:

I have one doubt in this following sheet:

1997
EU (27 countries) 100
EU (25 countries) 104,9
EU (15 countries) 115,5
Euro area 115,9
Euro area (15 countries) 0
Euro area (13 countries) 114,4
Euro area (12 countries) 114,7
Belgium 125,9
Bulgaria 26,5
Czech Republic 73,1
Denmark 133,5
Germany 124,6
Estonia 41,9
Ireland 115,1

If I change point for comma format in cells just change in several ones
but
not in all of them could you tell me please?

thanks