Question

  • Creator
    Topic
  • #3949765

    Excel date cipher

    by aadiel.willemse1 ·

    Tags: 

    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.

You are posting a reply to: Excel date cipher

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

  • Author
    Replies
    • #3949773

      Please clarify…..

      by birdmantd ·

      In reply to Excel date cipher

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

    • #3949775

      Re|: Excel dates

      by kees_b ·

      In reply to Excel date cipher

      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.

    • #3949778

      Number to letters

      by aadiel.willemse1 ·

      In reply to Excel date cipher

      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

      • #3949813

        Re: date to letters

        by kees_b ·

        In reply to Number to letters

        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.

    • #3973077

      Wufwuf Discount code

      by Joeroot1065373272 ·

      In reply to Excel date cipher

      Wufwuf Discount code is best code provided by Wufwuf . Amazing Discount Offers, Get Wufwuf & Promo Codes and save up to £40 on the offer, so get the code helps you to save on coupon and promo codes.https://uttercoupons.com/front/store-profile/wufwuf-discount-code

Viewing 3 reply threads