warning when sorting

P

P D Sterling

I know your Excellencies will all have a heart attack, but I use a lot
of Excel for small databases. Nothing entered is a calculable number,
they are all codes. When I sort, say, ZIP CODE - the operative word her
being CODE, it says, Hey there, do you know that some of the numbers in
this column are formatted as text? and I set here and tell the computer,
Well, duh!!

I have all the auto-correct and auto-fill features turned off - is there
a way to get rid of this unhelpful reminder?
--

Regards,

P D Sterling
Dallas TX
 
G

Guest

To the best of my knowledge nope. That reminder is going to pop up whether
you want it or not...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort Key Warning 3
Documents on the Start Menu 10
tray icons 2
Sort by how many addresses per zip code 4
sorting 4
Sorting data with the letter 'E' included 3
sorting column of numbers 1
Numbers to sort as text 5

Top