Thread: how do I create a Date field format for mm/dd/yyyy (10 digits)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do I create a Date field format for mm/dd/yyyy (10 digits)
Enter data like
=TODAY()
It should already be formatted to appear as
10/26/2006
if not then re-format the cell

When the column is filled then save the file as .txt
--
Gary's Student


"The Big Kahuna" wrote:

Trying to create a text file with a standard 10 digit column containing dates
Reply With QuoteReply With Quote