| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Birthdate 01/01/2000 Remove Slashes
We are trying to remove the slashes in the birthdate field but keep the
leading zero. We have used text to columns to separate the fields, then converted the columns to text and added any missing zeros, but we can't seem to get the concatenate field to work after that. There must be an easier way. Help is appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Birthdate 01/01/2000 Remove Slashes
Sprowler,
Format the cell as one of the date options without /s, or use a custom format mm dd yyyy or use = TEXT(A1,"mmddyyyy"), or =MONTH(A1), = DAY(A1), = YEAR(A1) etc.. HTH, Bernie MS Excel MVP "Sprowler" wrote in message ... We are trying to remove the slashes in the birthdate field but keep the leading zero. We have used text to columns to separate the fields, then converted the columns to text and added any missing zeros, but we can't seem to get the concatenate field to work after that. There must be an easier way. Help is appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Birthdate 01/01/2000 Remove Slashes
Format Cells... Number Custom ddmmyyyy
-- Gary''s Student - gsnu200852 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Birthdate 01/01/2000 Remove Slashes
Thank you! This was awesome!
"Bernie Deitrick" wrote: Sprowler, Format the cell as one of the date options without /s, or use a custom format mm dd yyyy or use = TEXT(A1,"mmddyyyy"), or =MONTH(A1), = DAY(A1), = YEAR(A1) etc.. HTH, Bernie MS Excel MVP "Sprowler" wrote in message ... We are trying to remove the slashes in the birthdate field but keep the leading zero. We have used text to columns to separate the fields, then converted the columns to text and added any missing zeros, but we can't seem to get the concatenate field to work after that. There must be an easier way. Help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove link to other files in Excel 2000 | Excel Discussion (Misc queries) | |||
| How to remove leading zeros using excel 2000 | Excel Discussion (Misc queries) | |||
| remove the watermark in Excel (2000) "Page1" | Excel Discussion (Misc queries) | |||
| I cannot remove a link in excel 2000? | Excel Worksheet Functions | |||
| How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
