Hi

I have Ref column in decimal format,

Table Example:

FileName Ref

File1Test 1.0

File2Test 1.1

File3Test  1.2

File4Test   1.1.1

I want sorted table to look like

FileName Ref

File1Test  1.0

File2Test  1.1

File3Test  1.1.1

File4Test   1.2

Is this kind of sorting possible?

Please help!

Thanks

• Edited by Meenakshi7626 20 hours 44 minutes ago

Is this a Visio question?

Hi Meenakshi7626,

From your description, it seems an Excel issue rather than a Visio issue, am I right? If yes, we can sort one column in a range of cells without affecting the others. Steps:

1.Select a column in a range of cells containing two or more columns.
2.To select the column that you want to sort, click the column heading.
3.On the Home tab, in the Editing group, click Sort & Filter, and then click one of the available sort commands.
4.The Sort Warning dialog box is displayed.
5.Select Continue with the current selection.
6.Click Sort.
7.Select any other sort options that you want in the Sort dialog box, and then click OK.

Please note: Be careful when using this feature. Sorting by one column in a range may produce results that you don't want, such as moving cells in that column away from other cells in the same row.

Quote From:

https://support.office.com/en-in/article/Sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654

If I misunderstand something, please feel free let me know.

Regards,

George Zhao
TechNet Community Support