 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2008DateValue problem
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel There is probably a simple answer that I cannot see, but: Cell A1 contains a date and the cell is formatted to to a date (eg: 03/11/2008) - UK style Cell A2 contains: =DateValue(A1) Simple.....but I get the #VALUE error. In fact I get it on all datevalue references to cells, but not on a date inserted in quotes into the formula. H.E.L.P please On 6/25/08 5:47 AM, in article 59b52414.-1@webcrossing.caR9absDaxw, > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) [quoted text clipped - 10 lines] > > H.E.L.P please You are getting the error because DATEVALUE requires its argument in text format. When you pass a cell reference, the date gets passed as a date serial number (the cell's value), NOT text (the cell's display).  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom > On 6/25/08 5:47 AM, in article 59b52414.-1@webcrossing.caR9absDaxw, > [quoted text clipped - 15 lines] > format. When you pass a cell reference, the date gets passed as a date > serial number (the cell's value), NOT text (the cell's display). So how do you fix it? I want to use a cell, not type in a date. On 7/7/08 11:28 AM, in article C607A445-4A92-47BE-B93F-0606BEB823C3@microsoft.com, "Biff" >> On 6/25/08 5:47 AM, in article 59b52414.-1@webcrossing.caR9absDaxw, >> [quoted text clipped - 17 lines] > > So how do you fix it? I want to use a cell, not type in a date. I'm not clear on what you are actually looking for - It sounds like you want A2 to display the same as A1. If so, A2 need only contain the expression =A1 which you can then format as you wish for displaying the same date. If you want the numerical value of the date displayed format the cell as Number or General rather than as Date. HTH |:>) Bob Jones [MVP] Office:Mac On 7/7/08 11:28 AM, in article C607A445-4A92-47BE-B93F-0606BEB823C3@microsoft.com, "Biff" >> On 6/25/08 5:47 AM, in article 59b52414.-1@webcrossing.caR9absDaxw, >> [quoted text clipped - 17 lines] > > So how do you fix it? I want to use a cell, not type in a date. There is nothing to FIX. It is not broken. You are misunderstanding something and I do not know what; so I can't properly explain a solution. Like Cybertaz asked: What are you trying to do? Why do you feel the need to use DATEVALUE? SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom > On 7/7/08 11:28 AM, in article > C607A445-4A92-47BE-B93F-0606BEB823C3@microsoft.com, "Biff" [quoted text clipped - 24 lines] > Like Cybertaz asked: What are you trying to do? Why do you feel the need to > use DATEVALUE? I have a date (3/1/2008)in F5. This is the formula in J5, =DATEVALUE(F5). I want to see 39508 in J5. Instead I see #Value. On 7/7/08 2:10 PM, in article EBBB9A40-5C98-4793-A480-486FB05FAA4A@microsoft.com, "Biff" >> On 7/7/08 11:28 AM, in article >> C607A445-4A92-47BE-B93F-0606BEB823C3@microsoft.com, "Biff" [quoted text clipped - 28 lines] > I have a date (3/1/2008)in F5. This is the formula in J5, =DATEVALUE(F5). > I want to see 39508 in J5. Instead I see #Value. Just use the formula =J5 in F5 and format it as general. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.