Results 1 to 3 of 3

Excel 2007 : Data validation issue

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2006
    Posts
    8

    Question Data validation issue

    I have a spreadsheet I use that has data validation for cells with currency amounts. I use the semicolon as a list separator and have it setup in control panel that way.

    The spreadsheet is a template, when I open it, it functions fine the dropdown boxes work. However when I go to save it, and open it again it somehow has replaced all the commas with semicolons and the dropdown boxes do not work correctly.

    This is a very recent occurrence, it used to work fine. Any ideas out there?

    Running on windows server 2000 and excel 2007, also does the same thing on windows xp machine I have. Makes no difference if I save it as macro enabled, template, etc
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1