SOLVED

Excel on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2955796%22%20slang%3D%22en-US%22%3EExcel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955796%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20change%20DOB%20to%208%20numbers%20on%20my%20excel%20sheet%20without%20having%20to%20go%20add%20in%20all%20the%20leading%20zeros.%26nbsp%3B%20%26nbsp%3BI%20have%20my%20cells%20in%20'text'%20format%20(I%20even%20tried%20it%20with%20CSV%20file)%26nbsp%3B%20Currently%20it's%20like%209122015%20and%20I%20need%2009122015.%26nbsp%3B%20%26nbsp%3BI%20need%20it%20in%20the%20format%20mmddyyyy.%26nbsp%3B%20%26nbsp%3B%20I%20have%20tried%20Format-cells-custom%20and%20put%20in%20mmddyyy%20in%20the%20'type'%20but%20it%20just%20changes%20my%20numbers%20to%20%23%23%23%23%23%23%23%23.%26nbsp%3B%20%26nbsp%3BIf%20I%20try%20to%20widen%20the%20column%20it%20just%20keeps%20repeating%20%23%23%23%23%23%23%23%23.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20version%20on%20excel%20and%20my%20OS.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-11-11%20at%2011.52.47%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326373i4E6B7F839B232F86%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-11-11%20at%2011.52.47%20AM.png%22%20alt%3D%22Screen%20Shot%202021-11-11%20at%2011.52.47%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-11-11%20at%2012.05.43%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326374i2792D2248C7D7ED6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-11-11%20at%2012.05.43%20PM.png%22%20alt%3D%22Screen%20Shot%202021-11-11%20at%2012.05.43%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3EMy%20co-workers%20have%20an%20earlier%20version%20of%20Excel%20and%20it%20works%20on%20their%20computer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated.%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2955796%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2956020%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2956020%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1215638%22%20target%3D%22_blank%22%3E%40gaturner1953%3C%2FA%3E%26nbsp%3BTry%20using%20a%20custom%20format%2000000000.%20That%20is%2C%20eight%20zeros.%20That%20will%20change%20all%20your%20DOB%20numbers%20to%20what's%20in%20the%20picture%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-11-11%20at%2019.31.54.png%22%20style%3D%22width%3A%20157px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326376i50C2E9C25E737746%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-11-11%20at%2019.31.54.png%22%20alt%3D%22Screenshot%202021-11-11%20at%2019.31.54.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIs%20that%20what%20you%20need%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to change DOB to 8 numbers on my excel sheet without having to go add in all the leading zeros.   I have my cells in 'text' format (I even tried it with CSV file)  Currently it's like 9122015 and I need 09122015.   I need it in the format mmddyyyy.    I have tried Format-cells-custom and put in mmddyyy in the 'type' but it just changes my numbers to ########.   If I try to widen the column it just keeps repeating ########.

 

This is my version on excel and my OS.

Screen Shot 2021-11-11 at 11.52.47 AM.png

Screen Shot 2021-11-11 at 12.05.43 PM.png

My co-workers have an earlier version of Excel and it works on their computer.

 

Any help is appreciated.

2 Replies

@gaturner1953 Try using a custom format 00000000. That is, eight zeros. That will change all your DOB numbers to what's in the picture below:

Screenshot 2021-11-11 at 19.31.54.png

Is that what you need?

best response confirmed by gaturner1953 (New Contributor)
Solution
Yes!!!! Thank you so much!!