Question
September 17, 2007 at 08:38 AM
fernando

Date Code conversion in Excel

by fernando . Updated 19 years, 1 month ago

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.

This discussion is locked

All Comments