Hope it's OK to ask this he I am trying to sort a column of times 423PM,
958AM, 1034AM, 1245PM, etc.) but the sort puts the column this way - 1034AM,
1245PM, 423PM, 958AM. Why won't it put 958AM first?

Thanks in advance

"Frank Kabel" wrote:

Hi
the formula in column A probably causes this error. Try the following
before sorting:
- select column A and copy this column
- goto 'Edit - Paste Special' and choose 'Values' to remove the
formulas

Now try sorting again


--
Regards
Frank Kabel
Frankfurt, Germany


pm wrote:
OK, Thanks,
Row 1, has my column headings
Row 2 has invoice number in 2A, date in 2B, client in 2C and job in
2D. I have 350 rows of client information.
The form was created with all of the invoice numbers in order. My
goal was to sort them by client and keep all of the row info with
that entry.
I should tell you that part way through the entry a formula was used
to add the current invoice number +1, I don't know if that makes a
difference.
Anyway, when I select all 4 columns and 350 rows and fo to Data-Sort
by Client, it does sort by client but not all the invoice numbers
remain with that entry. One thing that it does do is put #VALUE! in
2A???
Does the formula mess it up?
Thanks again.


"Frank Kabel" wrote:

Hi
o.k. can you give an example of what exactly happens after the sort.
What changes within one row?

--
Regards
Frank Kabel
Frankfurt, Germany


pm wrote:
Yes I have.

"Frank Kabel" wrote:

Hi
have you selected ALL relevant columns before going to the menu
'Data - sort'?

--
Regards
Frank Kabel
Frankfurt, Germany


pm wrote:
I'm trying to sort my document that has 4 colums. Invoice #,
Date,
Client and Job.
I want to sort by Client and keep all row information intact.
When I select all and then Sort by Client, Excell does sort by
Client but it is not keeping the row info intact. What am I doing
wrong? Thank you.