Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting dates
Hi,
I need to convert the date format dd/mm/yyyy to yyyymmdd. How would I go by? TIA Ana |
#2
|
|||
|
|||
Hi Ana,
Assuming that you have a valid Excel date and not a string format, cells, custom yyyymmdd --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ana" wrote in message ... Hi, I need to convert the date format dd/mm/yyyy to yyyymmdd. How would I go by? TIA Ana |
#3
|
|||
|
|||
Ana wrote:
Hi, I need to convert the date format dd/mm/yyyy to yyyymmdd. How would I go by? TIA Ana Right click on the cell select format, under numbers select custom. In the type box put yyyymdd and hit OK. gls858 |
#4
|
|||
|
|||
If you have a "text" date, in A1, use this.........
=RIGHT(A1,4)&MID(A1,FIND("/",A1,1)+1,2)&LEFT(A1,2) Vaya con Dios, Chuck, CABGx3 "Ana" wrote in message ... Hi, I need to convert the date format dd/mm/yyyy to yyyymmdd. How would I go by? TIA Ana |
#5
|
|||
|
|||
Assuming A1 contains your date. =TEXT(A1,"yyyymmdd") -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310 View this thread: http://www.excelforum.com/showthread...hreadid=464268 |
#6
|
|||
|
|||
select the cell click Format cells select "custom" from the Category box In the "type" box type yyyymmdd Regards -- Bonzo123 ------------------------------------------------------------------------ Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182 View this thread: http://www.excelforum.com/showthread...hreadid=456961 |
#7
|
|||
|
|||
Hi Ana, no problem, just right click in the cell, and select "Format Cells" about half-way down the list. Select the "Number" tab. Select "Custom" from the category list. left click the "Type" box and use delete key to clear anything in this box (if it isn't empty already) and type in the date format of your choice, i.e. "yyyymmdd". You should see the date in the way you want in the "Example" box. This works because Excel holds dates as the number of days since 1 January 1900. So 9 September 2005 is held as 38604, tomorrow will be held as 38605, etc. Therefore Excel can convert this into a date in any format, so long as you tell it what you want. For fun, try using yyyyMMMDDD (not case sensative). HTH Art -- HiArt ------------------------------------------------------------------------ HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953 View this thread: http://www.excelforum.com/showthread...hreadid=464228 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop auto converting Text(Inventory#) to Dates | Excel Discussion (Misc queries) | |||
Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
Converting Text months to sortable Numbers or Dates | Excel Discussion (Misc queries) | |||
converting dates into numbers | Excel Discussion (Misc queries) |