Displaying a barcode number in a cell correctly.

I want to output data from a barcode data collection program into an Excel sheet. A straightforward number like a numeric sequence such as 5012345678900 displays OK under the 'general' format - but in the case of a GS1-128 barcode with Application Identifiers in the code the number is displayed like this in the cell:

1.50601E+22

Changing the format to 'number' results in this

15060099290985200000000.00

The actual barcode is (01)50600992909852(17)121003

How can I get the cell to show the barcode content exactly as shown above..?

Thanks in advance!

Hi

Think you will find that your number is to long, remember something about excel only handling 15 digits so you would need to change your number to text. Cant confirm this just a vague memory from something I read, hopefully someone will correct me if I an wrong.


Chris

Thanks, but I don't think that's the problem. The misrepresentation of the number has more than 15 digits, so I think the problem is in how Excel receives the data and shows it. I can only assume the ASCII string is correct, showing the brackets and digits, so what Excel won't display correctly flummoxes me...

Greg

Hi Greg

Could well be but I think the 15 digit bit is also causing you problems when you had the cell as numbers all the zero`s at the end of your number started at the 16th digit. Hopefully one of the gurus will look at this thread and put us both out of our misery.

Chris

let's hope!