Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problems with Functions (Excel 32003)

    When I insert a function into an cell the wizard inform me I don't need an , as part of the syntax. For example if I enter Left(B2,5) it does not accept it and if I look at the wizard it tells me to use Left(B2 5). It I use that it does not work

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problems with Functions (Excel 32003)

    That's what you get for using Excel 32003 <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    If you have Windows XP. open the Regional and Language Options control panel, click Customize..., activate the Numbers tab. I think in previous Windows versions it was the Regional Settings control panel, Numbers tab.

    What is the List Separator setting? That is the character you should use.

    You may also have to check Tools | Options... in Excel, International tab, Number Handling section.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems with Functions (Excel 32003)

    Thanks Hans. It is a nice way to "break" / confuse your enemies. This site rocks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •