Problems with Filters

[Dave Peterson]

Excel can convert some date/times correctly, but I've found it best to enter the
time as military time (but you could do 9:15 PM or 21:15 and the underlying
value will be equal--the formatted display may be different, though!)

I just like 19:15 and I don't have to be as careful. (9:15 PM <> 9:15PM)

and the formatting question.

Just select all the cells that you want to format first. (Rows/columns/ranges
or combinations, then format.) You'll be all set.

sandra wrote:
>
> I'm creating a "dayplanner" with several columns on Excel
> for Windows 97, I am using the "sort" option to put dates
> and times in ascending order but cannot seem to get times
> to work, any suggestions? Do I need to enter time in
> military notation? ex: 08:00 for 8AM. Also, can anyone
> tell me if there is a feature to apply one option to all
> cells ex: wrap text with size 8 font for all cells.
> Please help.
> Thanks,
> Sandra

--

Dave Peterson
ec3...@msn.com