Thread: converting date to number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default converting date to number

Perhaps this formula in another column

=TEXT(A1,"yyyy-mm-dd")

(assuming your regional settings are for US type date, i.e. mm/dd/yy)

If you have some entries which have been converted to date and some not
try

=IF(ISTEXT(A1),A1,TEXT(A1,"yyyy-mm-dd"))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513817

Reply With QuoteReply With Quote