LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default what is purpose of asterisk in date format *3/2/07?


excel2003
what is purpose of asterisk in date format *3/2/07?
when i use advance filter, a line with a date in it formated with the
asterisk gets filtered out, even though the data in the line satisfies all
criteria and should not be filtered out.
why?
 
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
What exactly does the asterisk mean in the Date/Time formats? JB Excel Discussion (Misc queries) 1 July 26th 06 02:39 AM
explain purpose of {} cereldine Excel Discussion (Misc queries) 1 April 4th 06 12:57 PM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM
What is the purpose for a Spreadsheet? Trainboy85 Excel Discussion (Misc queries) 4 February 25th 05 02:24 PM
What is the purpose for a Spreadsheet? pjneal_uk_2002 Excel Discussion (Misc queries) 0 February 24th 05 03:29 PM


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

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

About Us

"It's about Microsoft Excel"