Excel on Mac

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)
Yes!!!! Thank you so much!!