I am trying to use DATEVALUE function to convert the date (01/10/2009) to value. I have the date in cell A2 and when I use DATEVALUE(A2) it gives me an error. However, adding ' before the date eliminates this error. I have several rows of data like this and cannot add ' before each one of them manually. Is there a way to get around this problem? Thank you.
Hello,
Try this =DATEVALUE("1/10/2009")
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
what do you mean by converting date to a value?. It already is a value. Do you mean you want to see the serial number value? If so format the cell as General.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
NBVC, changing the format worked fine. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks