How do I change the number format for decimals from , to .?

N

Nicole

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!
 
B

bpeltzer

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).
 
P

Peo Sjoblom

I suspect Nicole's data is text or else excel will do necessary conversions
from different regional settings
I have Swedish Excel on a virtual PC with Swedish Windows XP and Swedish
regional settings and we use the same number format as the Dutch and I
constantly move files between that and my English Excel without problems
--
Regards,

Peo Sjoblom

(No private emails please)
 

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 does not accept text format! 0
How to count the numbers in a Word document? 0
Mail Merge - displaying a conditional number of decimals 5
Using project as a resource tracker 0
Table of content - format does not get saved 2
value field preferences 1
How can I change the default number of decimal places in Excel? 1
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5

Top