Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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 In article , CP wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |