Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number format for decimals from , to .?
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! |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I change the number format for decimals from , to .?
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) "bpeltzer" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
how to change the h:mm format to number? | Excel Worksheet Functions |