Question Locked

Date Code conversion in Excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I want to create a way in Excel to convert a regular date (say "09/17/07") into a code that will go on our products for our clients to decode visually, using a format such as:

M=1
U=2
R=3
K=4
Y=5
C=6
L=7
O=8
W=9
N=0

So, "09/17/07" would be recoded to be "NWMLNL".
I'm sure this is possible, and probably a lot simpler that I imagine. Any help would be greatly appreciated. Thanks in advance.

1 reply

This discussion is closed to new replies.