Thread: Changing text dates to date serial numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Changing text dates to date serial numbers
In B2: =TEXT(A1,"m/d/yyyy")

format cell as General, copy down


"George" wrote:

I have the following in a spread sheet:
Pay Date
01/05/2007 #VALUE!
01/05/2007 #VALUE!
01/05/2007 #VALUE!
01/11/2007 #VALUE!
the Pay Date is in column A1 and the function is in B2
the function that returns the "#VALUE!" error is "=DATEVALUE(A2)

why do I get an error? I'm using Excel 2003 (11.8146.8132) SP2
Reply With QuoteReply With Quote