Sort Table

[APML]

Hi All, I have a table with numerous columns, all the columns get their data from other cells (there are no fourma's... i.e the cells within the table are something like =Conf_1!R5).
All the cells in the table are formatted to 4 decimal place currency and all the cells that the data is coming from are formatted 4 decimal currency...so formatting is same
My problem is, some of the columns in my table sort "smallest to largest (which is what I want), but other sort "A to Z".
Can anyone tells me how to fix this

 

[APML]

problem solved

 

[Peter_SSs]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.