Re: insert a range of date

Format>Cells>Number, choose Date and select one of the examples.
If none fits your requirements:
Format>Cells>Number, choose Custom. In the Type box, enter: dd mmm yyyy

--
Kind regards,

Niek Otten

"Lynn" <moley_cruz@xxxxxxxxxxxx> wrote in message
news:1133623906.049487.66760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> how can i convert 02/12/2005 to 02 Dec 2005 ?
>


.

Relevant Pages

  • Re: help file?
    ... Kind regards, ... > Any good links to tutorial how to write small help for each custom ... > function in excel? ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Adding up times
    ... Format the total as Custom: ... This will prevent the sum from topping over at 24 hours ... Kind regards, ...
    (microsoft.public.excel)
  • Re: basically want to go from mm/dd/yyyy to yyyymmdd
    ... tab, Custom, in the Type box, enter: yyyymmdd ... Kind regards, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can I create a slideshow in Word?
    ... Create a document using a custom page size that fits on screen, ... > PowerPoint, and I am wondering if it is possible to create a slideshow in ...
    (microsoft.public.word.docmanagement)
  • Re: help file?
    ... In help file ... > have any workbooks. ... > have that information stored in any workbook I open and use my custom ... >> Kind regards, ...
    (microsoft.public.excel.programming)
Loading