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
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