Entering dates
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Entering dates

  1. #1
    New Member
    Join Date
    Jan 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Prior to an upgrade from XL97 to XL2000 I was able to enter a date such as April 8 2002 as 080402. Now XL is interpreting 080402 as 80402 (dropping the leading 0) and the formatted result is February 17 2120. Any ideas on how I might be able to enter dates without requiring separater symbols such as '/' and '-'.

    Any feedback will be much appreciated.
    NM

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-14 23:45, NorthMelbourne wrote:
    Prior to an upgrade from XL97 to XL2000 I was able to enter a date such as April 8 2002 as 080402. Now XL is interpreting 080402 as 80402 (dropping the leading 0) and the formatted result is February 17 2120. Any ideas on how I might be able to enter dates without requiring separater symbols such as '/' and '-'.



    Any feedback will be much appreciated.
    NM
    Hi NM
    Your xl97 book may have had the cell formated as;

    Custom > ddmmyyy

    Just change the cells format to the above
    ie.

    Select Format > Cells > Number
    Custom enter ddmmyyy


    Kind Regards,
    Ivan F Moala From the City of Sails

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com