Question Locked

Excel date cipher

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi All,was hoping anyone could please help by providing me with a formula to change date to text,would like to change the numbers into alphabetic letters and then decipher it again when I need to.

4 replies

by birdmantd edited

Do you mean converting 2/24/2022 to February 24, 2022 as an example? Need more information to offer advice.

by kees_b edited

To show it with letters on the screen, is not a formula, it's a format.
Like it's not a formula, but a format, to show a floating point number with 1 or with 7 decimals.

In fact, a date or date/time in Excel is just a number. Right now, when I write this, the date/time is approximately 44,616.632204

You're asking for something that doesn't exist.

by aadiel.willemse1

Hi, i would like to turn the date to letters,for instance 22/02/2004 would then show in Excel as ijdkoahjdkd or any letter we assign to a digit/number

by kees_b edited

That makes it clear. Then you have to write your own function in Excel. Input is the date (an integer if only a date, not the time also). Output is a string consisting of lower case letters.

Don't forget to write the reverse function also.

Google tells more about writing your own function: google for EXCEL CREATE CUSTOM FUNCTION

You might need some basic knowledge of math and programming. Or money to pay someone to do it for you. Or a friend that does it for free.

This discussion is closed to new replies.