Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I change a point for a coma between two numbers format dont cha
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I change a point for a coma between two numbers format dont cha
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Coma Separator in Numbers | Excel Discussion (Misc queries) | |||
Can not add numbers or change cell format | Excel Discussion (Misc queries) | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
numbers dont round up | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |