PC Review


Reply
Thread Tools Rate Thread

decimals changed to commas

 
 
tnaga
Guest
Posts: n/a
 
      23rd Nov 2003

excel vX for mac.
i have used excel for years, then 3 days ago, all of my excel file
have changed from decimals to commas (ie: 2.33 is now 2,33). formula
do not work using decimals (but commas work). how do i change th
commas back to decimals?
thank you, te

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      23rd Nov 2003
Ted

Not running a Mac, but in Windows OS the comma or dot is set in Regional
Settings in the Control Panel.

Probably a system alteration 3 days ago caused your problem.

Gord Dibben XL2002

On Sun, 23 Nov 2003 10:58:21 -0600, tnaga <(E-Mail Removed)>
wrote:

>
>excel vX for mac.
>i have used excel for years, then 3 days ago, all of my excel files
>have changed from decimals to commas (ie: 2.33 is now 2,33). formulas
>do not work using decimals (but commas work). how do i change the
>commas back to decimals?
>thank you, ted
>
>
>------------------------------------------------
>~~ Message posted from http://www.ExcelTip.com/
>~~View and post usenet messages directly from http://www.ExcelForum.com/


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Commas where decimals should be Gord Dibben Microsoft Excel Worksheet Functions 0 21st Jun 2006 06:47 PM
Re: Commas where decimals should be Jon Quixley Microsoft Excel Worksheet Functions 1 21st Jun 2006 02:40 PM
Re: Commas where decimals should be David Biddulph Microsoft Excel Worksheet Functions 0 21st Jun 2006 02:26 PM
Re: Commas where decimals should be Bob Phillips Microsoft Excel Worksheet Functions 0 21st Jun 2006 02:09 PM
Removing Decimals and Commas from a value =?Utf-8?B?U2VuZCBPYmplY3QgQ29tbWFuZCAtIFR3byBhdHRh Microsoft Access 4 11th Nov 2005 01:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:31 PM.