Exporting to Excel...problems, problems

I'm exporing a simple matrix report to excel. Once exported I want to sort on
a particular column but it errors out..."This operation requires merged cells
to be identically sized." If I highlight all the cells then go to format ->
cells - > uncheck merge cells it still does not work. The numeric data in the
columns is being treated as text. Can someone please offer some suggestions?
the matrix is quite simple. Person, month columns with the data being the
count per month.
Thanks,Did you try using Data/Text to Columns... on the column of data in question?
"Brian L" wrote:
> I'm exporing a simple matrix report to excel. Once exported I want to sort on
> a particular column but it errors out..."This operation requires merged cells
> to be identically sized." If I highlight all the cells then go to format ->
> cells - > uncheck merge cells it still does not work. The numeric data in the
> columns is being treated as text. Can someone please offer some suggestions?
> the matrix is quite simple. Person, month columns with the data being the
> count per month.
> Thanks,