ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I create a Date field format for mm/dd/yyyy (10 digits) (https://www.excelbanter.com/excel-worksheet-functions/116269-how-do-i-create-date-field-format-mm-dd-yyyy-10-digits.html)

The Big Kahuna

how do I create a Date field format for mm/dd/yyyy (10 digits)
 
Trying to create a text file with a standard 10 digit column containing dates

Gary''s Student

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



All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com