T
therube
Below is the outcome of my sort when the cells were formatted as number
These are currency values. I copied and pasted the information from a
website into Excel and all cells were formatted as "General" when I checked
my spreadsheet. I have tried to change the cell formatting to everything
imaginable, currency, numbers, removed commas, cleared $ sign formats etc yet
it appears that Excel is treating these numbers as text.
The help section said to change the cell format to number from text. Yet the
data was formatted as "general".
It seems to be sorting from the left rather then by total value.
99198
9500
94012
92661
9175
9172
88933
86999
86250
8620
86154
8400
82335
81678
795888
78689
765552
Thanks for your help.
These are currency values. I copied and pasted the information from a
website into Excel and all cells were formatted as "General" when I checked
my spreadsheet. I have tried to change the cell formatting to everything
imaginable, currency, numbers, removed commas, cleared $ sign formats etc yet
it appears that Excel is treating these numbers as text.
The help section said to change the cell format to number from text. Yet the
data was formatted as "general".
It seems to be sorting from the left rather then by total value.
99198
9500
94012
92661
9175
9172
88933
86999
86250
8620
86154
8400
82335
81678
795888
78689
765552
Thanks for your help.