| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add "/" to a date string
I have dates of birth entered into a column as 41384 which I would like to
insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add "/" to a date string
=DATE(RIGHT(A1,2),LEFT(A1,1+(LEN(A1)=6)),MID(A1,2+ (LEN(A1)=6),2))
Hope this helps. -- John C "bpc" wrote: I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add "/" to a date string
Got it. Thx
"John C" wrote: =DATE(RIGHT(A1,2),LEFT(A1,1+(LEN(A1)=6)),MID(A1,2+ (LEN(A1)=6),2)) Hope this helps. -- John C "bpc" wrote: I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add "/" to a date string
with your date in A1.. try the following formula in B1
=LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2) Drag it down as far as needed and then you can copy column BPaste SpecialValues in column A and delete column B. Does that help? "bpc" wrote in message ... I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add "/" to a date string
Hi
try marking your columnDataText to columnsNextNextDateM/D/YFinish -- Regards Roger Govier "bpc" wrote in message ... I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add "/" to a date string
This also works...
=TEXT(A1,"0\/00\/00") -- Rick (MVP - Excel) "bpc" wrote in message ... I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add "/" to a date string
On Fri, 5 Sep 2008 09:24:01 -0700, bpc wrote:
I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a leading zero (4 for April not 04), however the day of month always does. =TEXT(A7,"0\/00\/00") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
