View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default the difference about formula in two accounts

On Thu, 21 Sep 2006 00:26:01 -0700, Hoang
wrote:

I have two accounts A and B. When I log in user A, I use my excel to do
function RANK, it has a strutu RANK(number; ref ; [order]). But when I
When I log in user B, I use my excel to do function RANK, it has a strutu
RANK(number, ref , [order]).
Why it is different between ";" and "," in my excel. Is there something
wrong about your software?


No, nothing wrong with Excel, just a different setting in the Windows
Regional Settings.

Go to the Control Panel, Select Regional Settings, choose the Number
Tab and look at the list seperator.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________