Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
2 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel date formats not working.
Posted on 2016-08-29
Hi there experts,
I have a 6 digit date format that I want to switch to dd-mmm-yyyy
My date format looks like 080216 (Aug 08 2016)...... I need to look like, 08-Aug-2016
I have tried everything I know. I need help.
Thanks so much.
I have a 6 digit date format that I want to switch to dd-mmm-yyyy
My date format looks like 080216 (Aug 08 2016)...... I need to look like, 08-Aug-2016
I have tried everything I know. I need help.
Thanks so much.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
- +1
9 Comments
Active today
There are two ways to achieve this..
Assuming your date string is in A2, then
1) try the formula =DATE("20"&RIGHT(A2,2),LEF
2) Or try the formula =TEXT(DATE("20"&RIGHT(A2,2
Assuming your date string is in A2, then
1) try the formula =DATE("20"&RIGHT(A2,2),LEF
2) Or try the formula =TEXT(DATE("20"&RIGHT(A2,2
Roy,
Sorry limited VBA skills here.
Does the code go into "ThisWorkbook" or in "new module"
And how do i run it?
Thanks
Sorry limited VBA skills here.
Does the code go into "ThisWorkbook" or in "new module"
And how do i run it?
Thanks
Active today
Okay try this....
=TEXT(DATE("20"&RIGHT(A2,2),LEFT(A2,LEN(A2)-4),IF(LEN(A2)=6,MID(A2,3,2),MID(A2,2,2))),"dd-mmm-yyyy")
Active today
Hi,
pls try
pls try
=TEXT(DATE("20"&RIGHT(A2,2),LEFT(A2,LEN(A2)-4),MID(TEXT(A2,"000000"),3,2))),"dd-mmm-yyyy")
Featured Post
Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation)
David Miller (dlmille)
Synopsis
In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses
Course of the Month2 days, 17 hours left to enroll
696 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.