Author Topic: 4POS Uploading CSV barcodes changing?  (Read 7258 times)

0 Members and 1 Guest are viewing this topic.

leanne

  • Guest
4POS Uploading CSV barcodes changing?
« on: May 09, 2012, 09:31:58 AM »
Question:

''I've attached two csv files, one that I've worked on, once saved it changed the barcodes, the other I've not worked on and the barcodes are fine.''

From: Nigel Building and Hardware

Answer:

The problem is that when you save a spreadsheet as a "CSV" file & re-open it, the barcodes are displayed as a number & because it is so large it is showing as +2.340404....

You need to Highlight the barcode column --> right click --> Format Cells --> Go to number, make sure that separator decimal places is on 0 and un-click the tick - use 1000 separator
« Last Edit: May 11, 2012, 04:16:38 PM by admin »