• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

Date Formatting

Hi,

Where i have     =now()

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


I want to return 14 Sep

How do i change this?

Thanks
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
NBVCCommented:
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.
0
 
Seamus2626Author Commented:
Off course, thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now