4POS Support

4POS => 4POS FAQ's => Topic started by: leanne on May 09, 2012, 09:31:58 AM

Title: 4POS Uploading CSV barcodes changing?
Post by: leanne 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