Birthdate 01/01/2000 Remove Slashes

S

Sprowler

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.
 
S

Sprowler

Thank you! This was awesome!

Bernie Deitrick said:
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
Click to expand...
 
S

Sprowler

Thank you! This was awesome!

Bernie Deitrick said:
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
Click to expand...
 

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

Concatenating two variable fields into a static length text field 2
Remove slash charaters from a date field 3
Leading Zeros with a twist. 1
Keeping lead zeros in excel text format when saving as CSV file 1
csv format drops a text character when reopened in Excel 1
Concatenate Text Strings over Array 8
AutoIncrement Text Field in an Insert Statement 12
Best Table Structure 2

Top