• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

#VALUE error while changing date format

L

Learning_bee

New Member
I have some dates in text format and I want to change them into date format(number format). I am using DATEVALUE function but it is showing #VALUE error.
I have also tried changing my system's date format but nothing seems working. I have attached an example workbook.
 

Attachments

  • Book1.xlsx
    9.2 KB · Views: 8
Learning_bee
Your A-column values are correct (numbers).
You'll get #VALUE because there should be text.
You can test it eg with cell C3 =A1+1 or =ISNUMBER(A3)
Those are formatted as dd-mm-yyyy.
How would You like to see those A-column values?
 
vletm said:
Learning_bee
Your A-column values are correct (numbers).
You'll get #VALUE because there should be text.
You can test it eg with cell C3 =A1+1 or =ISNUMBER(A3)
Those are formatted as dd-mm-yyyy.
How would You like to see those A-column values?
Click to expand...
I want them in yyyy-mm-dd format... but if the dates format is correct then why are they coming in left side of the cell instead of right side..
 
Learning_bee
.. but if the dates format is correct then why are they coming in left side of the cell instead of right side..
Because someone has align those to left...
Screenshot 2022-09-10 at 10.14.52.png
... if You could change that to General-Format -- You'll see those values as below
Screenshot 2022-09-10 at 10.15.06.png
 
Learning_bee
Everywhere are rules, which are for You Learning_bee too, which You seems to skipped.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

    Please, reread Forum Rules before You'll continue posting.
 
Last edited:
vletm said:
Learning_bee
Everywhere are rules, which are for You Learning_bee too, which You seems to skipped.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

    Please, reread Forum Rules before You'll continue posting.
Click to expand...
Sorry I'll keep that in mind from next time.
 
You must log in or register to reply here.
Back
Top