Re: Format cells
Chip Pearson has some techniques that convert your input to dates at:
http://www.cpearson.com/excel/DateTimeEntry.htm
Helen wrote:
>
> I have been trying to type the dates with this format mm/dd/yyyy, but I would
> like not to do it everytime I want to insert a different date. I just want
> to type the numbers, and that excel put the date format automaticaly without
> me typing the // or formating it each time a put a different date.
--
Dave Peterson
.
Relevant Pages
- Re: Format a column wihtout using "Format-Cells-Number-category-et
... Chip Pearson has a very nice addin that will help determine what that ... "serve" wrote: ... excel spreadsheet. ... Is there a better way to match the format of columns I am comparing to text ...
(microsoft.public.excel.worksheet.functions) - Re: Conditional Formatting Dilema
... Disregard the last post. ... "Chip Pearson" wrote: ... format for yellow. ... turn yellow. ...
(microsoft.public.excel.misc) - Re: Conditional Format Using AND
... Chip Pearson ... www.cpearson.com "Coyote" wrote in message ... >> your second format condition will always be true and red>> format ... >> Microsoft MVP - Excel ...
(microsoft.public.excel.misc) - Re: Formula appears instead of value
... > Most likely the cell is formatted as Text. ... Change the format to ... > Chip Pearson ... >> What would cause a formula to display instead of the result. ...
(microsoft.public.excel.misc) - Re: Replace Line Feed
... Chip Pearson wrote: ... I you format back to unwrap, ... I have a spread sheet with a lot of Line Feeds, ... Dave Peterson ...
(microsoft.public.excel.misc) |
|
