spreadsheet that has birthdate without back slashes

  • Thread starter Thread starter oppygirl
  • Start date Start date
O

oppygirl

Hi... Looking for someone to tell me how to convert my
data of BIRTHDATE on a spreadsheet from... ex.

Name B-Date
John Doe 03/24/53

switch it to look like this... per IRS!

John Doe 032453

Without having to input all the birthdates again...
 
oppygirl said:
Hi... Looking for someone to tell me how to convert my
data of BIRTHDATE on a spreadsheet from... ex.

Name B-Date
John Doe 03/24/53

switch it to look like this... per IRS!

John Doe 032453
Click to expand...

If it's a date value, change the number format to mmddyy.
 
If 03/24/53 is in A1 and it's TEXT......you can put this formula in B1 and
copy down.......

=LEFT(A1,2)&MID(A1,4,2)&RIGHT(A1,2)

Vaya con Dios,

Chuck, CABGx3
 
Back
Top