Function Parameters

P

Paddyk

Hi all,

I'm having a strange problem using functions in Excel and I wonder if
anyone can help me. Instead of displaying as commas, parameters are
being seperated by 0's. Even the function help is comming up as e.g.
Max(number10[maxnumber20]) , resulting in formalus being shown like
this:
=MAX(a10a2) instead of =MAX(a1,a2).

I wonder if any of you have seen this before?
 
D

Dave Peterson

Maybe it's a windows setting that's screwed up.

I'd close excel
windows start button|settings|control panel|regional and language options
(or regional settings)
Then customize button (winXP)
then Numbers tab
look at the list separator.

Most USA users use a comma.
Others use a semicolon.

Hi all,

I'm having a strange problem using functions in Excel and I wonder if
anyone can help me. Instead of displaying as commas, parameters are
being seperated by 0's. Even the function help is comming up as e.g.
Max(number10[maxnumber20]) , resulting in formalus being shown like
this:
=MAX(a10a2) instead of =MAX(a1,a2).

I wonder if any of you have seen this before?
Click to expand...
 

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

Function Parameters 0
Running an Access function (with parameters) from Excel 6
how to use pivot data in formula or fuctions? 1
Running out of Functions 5
defining global function to be used in multiple cells 1
subform rowsource pass through to table value function w/ paramete 0
Comma used as decimal causing issues with parameter list 3
Adding comma seperated values within a single cell 2

Top