So I highighted a bunch of cells where numbers are stored as text and chose "ignore error". But when I re-sort the list, the errors come right back again.
Is there a way to get them to stick so I don't have to keep choosing ignore error?
So I highighted a bunch of cells where numbers are stored as text and chose "ignore error". But when I re-sort the list, the errors come right back again.
Is there a way to get them to stick so I don't have to keep choosing ignore error?
Perhaps File -> Options -> Formulas -> Error checking -> Error checking rules and remove tick from box "numbers formated as text"
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks