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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Integers appear as decimal fractions 1
Adjust the number of decimal points in Trendline equations 2
Decimal point vs comma 1
Formatting a Cell with a number without a decimal point 3
What Encoding is Used for Exporting Files inTab Delimited Text (.txt) Format? 1
How do I align currency decimals in cells? 2
Decimal places 6
Bug in Excel 2004 with Mac OS X 10.5 0

Top