Change comas to points for decimal values

R

Rodolphe_Koehly

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

I would like excel to use . instead of , for designating the limit with decimal values.
i.e: 5.1 intead of 5,1

When I use the replace tool it works but the values are not considered as values anymore.
It must be in the preference options but U can't find it.
The final aim is to import datas into matlab, which only woks with points.

If you have any clue, thank you very much...
 
C

CyberTaz

Excel picks up the designated decimal separator from the International
Preferences of OS X.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
Top