Do the values start with apostrophes? That's one trick to force Excel to treat numbers as text and the apostrophes only appear when editing the cell.
You could also try a =value(A1) formula in a different cell. Andy On Jul 14, 2016 7:25 PM, <[email protected]> wrote: > Tried both. Areas. Even single cells. > > *From:* Bill Prince <[email protected]> > *Sent:* Thursday, July 14, 2016 5:23 PM > *To:* [email protected] > *Subject:* Re: [AFMUG] OT Excel arrgh > > > What if you just do a column or row? > > bp > <part15sbs{at}gmail{dot}com> > > > On 7/14/2016 4:20 PM, [email protected] wrote: > > My wife did a large spreadsheet for me collecting a bunch of data. > All the cells have a little error flag on them saying they are text. > I try to highlight and format cell to number but they will not change. > The only way that works is to go to each cell, click on the error flag, > convert to number. > � > Any suggestions? > > >
