NAICS Code - Hirerachy Cell Format

[andersmw]

Hello,

I have a list of NAICS codes formatted as numbers that I would like to
format as hierarchical text.

Current List
10
12
101
112

Desired List
10
101
112
12

Does anyone know how to change the cell format so that the "Current
List" becomes the "Desired List"?

Thank you in advance for your help.

 

[Dave Peterson]

It looks like you could preformat that column as text and enter your values as
text. Then you could sort the data as text.

Some versions of excel will ask if you want to sort values that look like
numbers as numbers. You should say no to that prompt.

And just changing the format of the cells won't change the existing values to
text.

One way to change them to text is to insert a helper column and use a formula
like:
=a1&""

And drag down.

Then you could edit|copy this column and edit|paste special|values over the
original column.

Then delete that helper column.

 

[Harlan Grove]

On Jul 26, 2:10 pm, (e-mail address removed) wrote...
....

Current List
10
12
101
112

Desired List
10
101
112
12

....

Select current list, run the menu command Data > Text to Columns,
select Fixed Width, click the Next button twice to move to step 3 of
the wizard, select Text in the Column Data Format section, click
Finish. Then sort the list, and when the Sort Warning dialog appears,
choose Sort numbers and numbers stored as text separately.