Stupid formatting OCD

[BMR]

This is going to be a n00b question but it's bothering me and I can't figure it out without wasting more time.

I have a cell with a UPC code, ex- 781052055704

I want to take another UPC code of the same length and put it in the same cell, separated by a comma.

This is what I want:

781052055704,886587355704

Instead I either get scientific notation
7.81052055704886E+23 or
7810520557048860000000000

What formatting will work!?

 

[Weaver]

Set the cell formatting to 'text' - should fix

otherwise preceed the entire string with a single quote

 

[kpark91]

text

 

[prajul89]

change the format of the cells to text and it should work.

 

[BMR]

When I convert to Text format it still shows up in Scientific notation but once I click into and edit the cell it works. Weird, thanks all