Excel database number display issue
Excel database shows different number in bartender. The number in the excel file is 226622.001 and bartender reads it at 226622.0009999999. Doesn’t matter if you change the excel column it’s reading to number and limit the decimal places to 3. It’s a number being exported from SAP to a spreadsheet as text/ascii
0
-
It sounds like the ODBC is ignoring the formatting set in the spreadsheet and just passing through the raw data. I do not believe you can get round this in the ODBC/spreadsheet settings but would need to allow for this in the data field on the label itself.
If you go into the Properties of the field on the Data Type tab you adjust the Type to number and set this to three decimal places then that should sort it.
0
Iniciar sesión para dejar un comentario.
Comentarios
1 comentario