Date Formatting

Posted on 2012-09-14
Last Modified: 2012-09-14

Where i have     =now()

It returns "14/09/2012 17:57"

I want to return 14 Sep

How do i change this?

Question by:Seamus2626
    LVL 23

    Accepted Solution

    Select the cell then right-click and Format Cells.

    From the Number tab, select Date.

    Choose the one that comes closest to your request, probably one that say 14-Mar.

    If you want to replace the - with a space, go now to Custom.. you should see something like

    [$-409]d-mmm;@ depending on regional settings, in your Type field...

    you can replace the dash between the d and mmm with a space.

    Author Closing Comment

    Off course, thank you!

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now