Re: Sort Failing on Some Data
- From: "Mark Lincoln" <mlincoln@xxxxxxxxxxxxx>
- Date: 27 Jan 2006 10:08:27 -0800
Did you notice if the figures in the unsorted cells were entered with
leading apostrophes? That forces Excel to treat the entries as text
regardless of the cells' underlying format.
Re-entering a number without the apostrophe would fix the problem.
.
- Follow-Ups:
- Re: Sort Failing on Some Data
- From: John Pritchard
- Re: Sort Failing on Some Data
- Prev by Date: Excel 2000 on Win XP
- Next by Date: RE: Simple Report is such a pain!
- Previous by thread: Excel 2000 on Win XP
- Next by thread: Re: Sort Failing on Some Data
- Index(es):
