Skip to main content

Search

Search

Decimal Number To Fraction

Comments

11 comments

  • Avatar
    Levi Hargrove
    Moderator

    Hi there,

     

    Can you attach the label and an example excel file? (first 5 rows or something of that nature).

    0
  • Avatar
    Legacy Poster

    Yes, sounds like this may be an issue easier fixed in the Excel file than by some logic in the BarTender file.

    0
  • Avatar
    Legacy Poster

    Hello and Good day!
     
    Thank you for reply. I've attached the Bartender file, but I am having errors uploading the Excel file.

     

    This error message appeared: "

    • Die Excel.xlsx

      You aren't permitted to upload this kind of file

    Anyway, I change the cell formatting in Excel from decimal to fraction but comes to Bartender, when exported, numbers go back to it's decimal form.

     

    Thank you guys for helping out!

     

    Best regards

     

    [attachment=1121:Die1.btw]

    0
  • Avatar
    Levi Hargrove
    Moderator

    Try going into your Excel file->Save As->Save as CSV (Comma Delimitation), and see if you can attach it. I believe that should work. My only worry is it may not keep all the original data in-tact. 

     

    You can also the excel file into our technical support, put "Attention Levi" for the subject.

     

    techsupport@seagullscientific.com

     

    0
  • Avatar
    Legacy Poster

    Hello, thank you for your reply. Here are both the files that I am encountering the challenge with. 

    Thank you very much for your patience.

     

    All the best!

    0
  • Avatar
    Levi Hargrove
    Moderator

    Can you attach a screen shot of what you're seeing on your side? Is it anything like the screen shots i've attached? 

    0
  • Avatar
    Legacy Poster

    Apparently, when I export my Excel file as a database, it converts the file back to decimal numbers format, instead of fraction.

     

    Can I ask what type of excel file extension you used? Is it the CSV (Comma Delimitation) format?

     

    Thanks for you help! :)

    0
  • Avatar
    Levi Hargrove
    Moderator

    I thought it was a little fishy, because BarTender will never convert your data for you when it brings it in.

     

    Unless the Excel sheet is formatting the rows for you automatically, it should be staying as a fraction. Are you exporting this out of another program, into an Excel document? There really isn't a preferred method of file type, CSV works, but if you go that route you will need to add the database as a "Text" database, because that's what CSV is; comma separated value text file

     

    When you open your Excel document, is the data still in a fraction format?

    0
  • Avatar
    Legacy Poster

    I really appreciate your help Levi, 

     

    Originally, the Excel document's content was in decimal format, and what I did was change the cell formatting to fraction. 

    Are you saying that, if the original file is in decimal form, It will remain the same in bartender, even if I formatted the cells as a fraction?

     

    Sorry to sound so inexperienced.

    0
  • Avatar
    Legacy Poster

    Are you saying that, if the original file is in decimal form, It will remain the same in bartender, even if I formatted the cells as a fraction?

     

    First, remember that there are a lot of "quirks" with using Excel as a data source. As it's not a true database program, and as you've realized, does do some of it's own re-formatting.

     

    The value that goes into BarTender will be the value that is stored in Excel. However, Excel does not always display to you the "true" value of what's being stored. Especially if you have applied a format to it.

     

    The best way to preserve the data as you like may be to use excel to first convert the values to fractions, then File > Save As the file as a .csv or .txt and import that newly saved file.

    0
  • Avatar
    Legacy Poster

    Thank you Ryder! I really appreciate your help. :)

    0

Please sign in to leave a comment.