I have some old Excel spreadsheets of cemetery records that I'm converting to numbers. The new file has the numbered column of the order of the rows but it is not a true column. I need that numbered column to keep a record of it. Can I convert that numbering to a new column so I can retain that as a way to sort?
MacBook Air 11″, 10.14
For clarity, I think the "column" of row numbers in Excel was the list of row numbers down the left side of the table, the same row numbers that are seen in Numbers when the table is selected. It was not part of the table in Excel and was not part of the "record" in Excel but they were always there so it might have looked like it.
For clarity, I think the "column" of row numbers in Excel was the list of row numbers down the left side of the table, the same row numbers that are seen in Numbers when the table is selected. It was not part of the table in Excel and was not part of the "record" in Excel but they were always there so it might have looked like it.
If it is not a "true column", what is it?
In my opinion, leaving it is Excel would be a better choice if this file is ever going to be used by others. Excel is the de facto standard. Every other spreadsheet app can open Excel files. Only Numbers can open Numbers files and, even then, only newer versions of the Numbers app can open Numbers files that were ever opened in a newer version. I prefer Numbers for a lot of things but I often make a "backup" export to Excel for any documents I feel are important.
I have had to do that before as well to preserve the original sort order when you cant just resort by date or some other columns value easily.
add a new column and enter this formula
=Row()
Fill that formula down, then copy and past formula results over the column.
Add new rows numbers as you add new data
When saving excel file in number how to include numbered column
