Decimal Number To Fraction 关注

0
Avatar
Legacy Poster

Hi and good day to all! I am fairly new to this software and I really need help with this challenge I am encountering. I synced my EXCEL file to my Database Connection to have a sort of a continuous serialized printing. The problem that I have is that, my my fractions turns into decimal when I import the EXCEL database in my bartender. Is there a way for me to change the Decimal Numbers into fraction in the Bartender Software. 

 

Thank you for your time and I would really appreciate it if someone could shed a light. :)

 

All the best!

11 评论

0
Avatar
Levi Hargrove
版主
评论操作 固定链接

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
版主
评论操作 固定链接

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
版主
评论操作 固定链接

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
版主
评论操作 固定链接

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. :)

请先登录再写评论。