When connecting to an Excel Worksheet, numeric data prints in scientific notation on my label.
In Excel, if you enter a numeric value into a field, it automatically converts the number to scientific notation.
If you are creating a new worksheet, before entering any data, highlight all cells and select Format | Cells from the menu bar. Highlight 'Text' under the 'Number' tab for all columns.
If you have an existing worksheet, please follow the steps listed below:
- Open your worksheet file in Excel (sample.xls).
- Select File | Save As and choose the 'Text (Tab Delimited) (*.txt)' Save As Type (sample.txt).
- Save the File into a directory (c:\excel\sample.txt).
- Close the worksheet; choose File | Open and select the worksheet you exported (sample.txt). The Excel 'Text Import Wizard' opens.
- Choose Delimited for Step 1 and Tab for Step 2.
- Set all columns to Text For Step 3; click Finish.
- Save the file as an Excel file (sample.xls)
Reconnect the label to the Worksheet.
All supported LPS family product versions.
Any supported LPS Family product environment