If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Decimal point - how to change?
Hi!
This might be a stupid question but I'm SO frustrated right now! Excel uses a comma (",") as the default decimal point, how can I change this to a period (".")? My statistics package don't like commas you see... -M- --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Decimal point - how to change?
Go to The tools menu
select options Select the international tab Uncheck the box that says use system seperators then put a period in the box. Bruce "marsupilami " wrote: Hi! This might be a stupid question but I'm SO frustrated right now! Excel uses a comma (",") as the default decimal point, how can I change this to a period (".")? My statistics package don't like commas you see... -M- --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
Decimal point - how to change?
Seems I've got no "international"-tab under "tools/options" - could it
be 'cause I'm using Excel 2000? If so, where do I change it? Thanx 10^6 --- Message posted from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
Decimal point - how to change?
Išàk wrote...
Go to The tools menu select options Select the international tab Uncheck the box that says use system seperators then put a period in the box. ... Perhaps in recent versions of Excel. For Excel 2000 and prior, the OP would need to change system settings through Windows' Control Panel's Regional Settings applet. --- Message posted from http://www.ExcelForum.com/ |
#5
|
|||
|
|||
Decimal point - how to change?
Correct, introduced in 2002 I believe, it only handles decimal and thousand
separators.. -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "hgrove " wrote in message ... Isàk wrote... Go to The tools menu select options Select the international tab Uncheck the box that says use system seperators then put a period in the box. .. Perhaps in recent versions of Excel. For Excel 2000 and prior, the OP would need to change system settings through Windows' Control Panel's Regional Settings applet. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003 & Fixed Decimal Places | Aless | Setting up and Configuration | 3 | October 25th, 2004 05:26 PM |
Default new open files to 2 decimal places | Setting up and Configuration | 5 | June 21st, 2004 04:26 AM | |
Decimal Point Separator | Mark | Setting up and Configuration | 1 | March 19th, 2004 06:16 PM |
Excell Invoice Template - Mac 1998; change cell value | Andy B | Worksheet Functions | 0 | February 10th, 2004 08:48 AM |