ChopperJim
New Member
- Joined
- Oct 12, 2006
- Messages
- 4
The Excel spreadsheet has thousands of rows of birthdates. The admin used a Format, Cells, Number, Custom and then selected mmddyyyy and all was well until the recipient said they need that column in a text format. When I try to simply change the cell to a text format, it converts the mmddyyyy to a five digit number - not sure why. When I use Data, Text-to-Columns command, I lose the 0's on single digit days & single digit months. When I try the text function / formula; =text(A2,"0") it doesn't convert the custom format at all. I'm certain it's user error, but I'm still stumped!
Any suggestions, short of re-entry? Thanks in advance!
Rgds,
El Viejo
Any suggestions, short of re-entry? Thanks in advance!
Rgds,
El Viejo