Re: what is purpose of asterisk in date format *3/2/07?
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Mon, 14 May 2007 07:28:22 -0500
Does the asterisk appear in the formula bar when you select that cell? (or is
it the result of a formula?)
If it does, then that's not from number formatting.
If you're asking about the format|cells|number tab|date category dialog warning:
Date formats display date and time serial numbers as date values. Except for
items that have an asterisk (*), applied formats do not switch date orders with
the operating system.
Then these dates may display differently on pcs that have a different windows
short date format.
But I've never seen this affect data|Filter|autofilter when you do it manually.
mike01 wrote:
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?
--
Dave Peterson
.
- Prev by Date: Re: Help with formula
- Next by Date: Re: finding maximum, minimum in a range consists both Positive and Negative numbers
- Previous by thread: Re: How do I sort in Excel by a root e-mail like @yahoo.com?
- Next by thread: Re: convert one column into many columns
- Index(es):
Relevant Pages
|
