Number value as text

Question

I have a single cell with the value:

426,427,433,439,442

This isn't a number, rather a list of numbers. If I try to add another number to the list, for example, 679. Excel changes the cell to read:

679,426,427,433,439,000

If I select the cell and format it as "text", it changes to:

 4.26427E+14

I've tried various cell formatting options, but I can't seem to get Excel to treat these numbers like text.

Answer 1

Copy and paste the column into Notepad, format a new column in Excel as text. In Notepad select all, copy it back out from Notepad into the column in Excel that you formatted for text.

Answer 2

First place a single quote (apostrophe) in front of the set of numbers and add the latest value at the end appropriate position.

1. add (apostrophe) in front of numbers
2. add (comma's) between
3. add any number by adding a (comma)

Answer 3

Possibly:

=LEFT(A1,3)&","&MID(A1,4,3)&","&MID(A1,7,3)&","&MID(A1,10,3)&","&MID(A1,13,3)  

It seems you have a number 426427433439442 with the commas purely a presentational aspect of the formatting. I take it you want the commas and the only way now may be to insert them.