New call-to-action
Results 1 to 11 of 11

Thread: Properties/Format Style

  1. #1
    Member
    Real Name
    Bob Groome
    Join Date
    Oct 2006
    Posts
    6

    Default Properties/Format Style

    Format style is "grayed out " in Field Properties/Format. I want to format a field to show value in currency.

  2. #2
    Member
    Real Name
    Bob Groome
    Join Date
    Oct 2006
    Posts
    6

    Default Re: Properties/Format Style

    I found the problem. I am importing to a table from an Excel SS. A5 is importing my numeric fields as ExponentNumeric instead of Numeric. I have many fields and I import new data once a week so I don't want to change each field every week after importing. How can I get A5 to import these fields as Numeric?

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Properties/Format Style

    Quote Originally Posted by jansbobby1937 View Post
    I found the problem. I am importing to a table from an Excel SS. A5 is importing my numeric fields as ExponentNumeric instead of Numeric. I have many fields and I import new data once a week so I don't want to change each field every week after importing. How can I get A5 to import these fields as Numeric?
    There are several related earlier posts if you search on ExponentNumeric. Not that there's a solution.

  4. #4
    Member
    Real Name
    Bob Groome
    Join Date
    Oct 2006
    Posts
    6

    Default Re: Properties/Format Style

    To: Alpha Five tech support
    Is there any solution to this problem?

  5. #5
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,646

    Default Re: Properties/Format Style

    I'm not real familiar with this issue, but if the import problem can't be easily solved, then I'd suggest a workaround: Import to a temporary table, then append to a final table with fields designed as you wish. This is very easy to set up and automate, and should take no time at all to run.
    -Steve


  6. #6
    Member
    Real Name
    Bob Groome
    Join Date
    Oct 2006
    Posts
    6

    Default Re: Properties/Format Style

    That works but is extra work. Thanks.

  7. #7
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: Properties/Format Style

    Bob:
    I have responded to an earlier thread that had to do with importing from Excel and few days later an article appeared in the newsletter saying the same thing I said! (plagiarism?)

    Save the Excel SS as dbf and add the table to alpha. You might read my post or the Newsletter article.

    I am curious though as to why this happens? what is the size & format of the cells in Excel?

  8. #8
    Member
    Real Name
    Bob Groome
    Join Date
    Oct 2006
    Posts
    6

    Default Re: Properties/Format Style

    I did exactly that. Saved SS to dbf. All fields come in correctly. But I still have one problem with the table. I have a calculated field similar to this "(Field2-Field1)/Field1". In the table I have that was imported from Excel the calculated field works fine. In the table I saved as a dbf file I keep getting "Invalid or incomplete expression." The expressions are both the same in each table.

  9. #9
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,662

    Default Re: Properties/Format Style

    Check the field types for each table.

    I'll bet one table has the fields as numeric and the other table has them as character.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  10. #10
    Member
    Real Name
    Bob Groome
    Join Date
    Oct 2006
    Posts
    6

    Default Re: Properties/Format Style

    You were absolutely right. How careless of me not to check. I wonder why A5 chose to save 6 fields out of 100+ as character and the rest as numeric. Excel saved them as numeric.

    Thanks for your help.

  11. #11
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Properties/Format Style

    Quote Originally Posted by jansbobby1937 View Post
    I wonder why A5 chose to save 6 fields out of 100+ as character and the rest as numeric.
    Are the excel fields that import/convert as character formatted differently in excel? Left justified or something such?

Similar Threads

  1. Password format style
    By Tom Cone Jr in forum Archived Wishlist
    Replies: 1
    Last Post: 05-22-2007, 02:08 PM
  2. format style: Yes/No on column properties
    By Graham Wickens in forum Alpha Five Version 7
    Replies: 2
    Last Post: 10-30-2005, 02:34 PM
  3. New format style
    By Tom Cone Jr in forum Archived Wishlist
    Replies: 2
    Last Post: 03-14-2005, 01:30 PM
  4. XP STYLE LOOK
    By david chambers in forum Alpha Five Version 5
    Replies: 5
    Last Post: 07-08-2003, 06:09 PM
  5. Number Format Style suggestion
    By Rich Drabik in forum Alpha Five Version 4
    Replies: 0
    Last Post: 06-14-2000, 09:25 AM

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
  •