View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
bpeltzer
 
Posts: n/a
Default How do I change the number format for decimals from , to .?

Check Tools Options, in the number handling section of the International
Tab; it seems to offer the option you need (at least on my English version
of '03).

"Nicole" wrote:

I have data from an english version of excel, where decimals are with a
point, and am working with a dutch version of excel, where decimals are with
a comma. Is there any way to change the decimal format from a comma to a
point without having to buy a new version of excel? Help!