Manual sorting and number formatting query

[PPSS]

Hi,

I have 2 queries.

1.) Number formatting: I have a few numbers  in a column which are currently showing in as V-String (If i manually change it to Double or Integer shows an error). The numbers in that column are of different formats "9005120.215215", "5210", "-4578125.22" etc.

I need to convert all of them into a common number format with no decimal places and a thousand separator like "#,###". I am trying to use "Tonumber" option but somehow facing an issue.

2.) Can we manually specify an option to sort a column rather than default options like ascending and descending. Like I have 3 regions "EMEA", "APAC" and "AMRS" and the sort order should be AMRS first followed by EMEA and then APAC (which is not possible either by ascending or descending sort)

Thanks,

PS

[binuacs · Accepted solution]

@PPSS 

[binuacs · Accepted solution]

@PPSS you can manually specify some thing like below and sort based on that number . Just keep the region and sorting order separate later connect with the actual file with join or find replace then use the sort tool to sort the sort order field  

[PPSS]

Thanks a lot:)