Forum Discussion
Months to letters of the alphabet
Hello everyone, I'm hoping someone knows this. I have to combine 4 columns to make a unique tracking number for each order shipped. This has to consist of "MONTH+YEAR+PO+16", the only deal is... ...
Do you have the relevant date in a cell? Let's say it is in D1.
To return the letter, use the formula
=CHAR(64+MONTH(D1))
I do, it's in D2..however that's not working.
If I put numbers there, it returns the letter "A" no matter what number is input. but if I put the months (with words), it errors for #Value!
