#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default warning when sorting

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default warning when sorting

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

Jim Thomlinson


"P D Sterling" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Warning with near date Micos3 Excel Discussion (Misc queries) 4 April 30th 07 12:38 AM
Warning Message tom Excel Discussion (Misc queries) 4 December 13th 06 08:23 PM
sort warning D Hensley Setting up and Configuration of Excel 2 November 1st 05 12:46 AM
Sorting a-z | z-a ... removing pop-up "Sort Warning" MatthewTap Excel Discussion (Misc queries) 7 October 26th 05 08:09 PM
Warning!!! Paul Excel Worksheet Functions 6 August 2nd 05 05:58 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"