Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi: Is there a simple formula to change a date in a field from one format to
another, for example 24-Dec-2007 to read 12/24/2007? Thanks.
 
If you want to do it in place, use Format/Cells/Number/Date and choose
your preferred format.

If you want the result in a different cell:

B1: =A1

Format B1 as mm/dd/yyyy
 
You can't do this by a formula - you should select the cell and use
Format | Cells | Number (tab) then Custom and either scroll down until
you find a format you want or in the panel type mm/dd/yyyy.

Hope this helps.

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMULA??? 1
Extract the 2 Lowest % 3
Paste Formula 4
Seperate date and time 4
setting up sequence sets with only 3 repeat once in excel 2
Formula help requested 5
INDEX MATCH SMALL 12
Date/Time 1

Back
Top