how do I create a Date field format for mm/dd/yyyy (10 digits)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to create a text file with a standard 10 digit column containing dates
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is seeing the date as dd/mm/yyyy 4
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
changing text to date format 8
How do I calculate age using a 12 digit social security number in MS Excel? 0
converting dd/mm/yy to mm/dd/yyyy 3
sumifs, sumif with dates 6
Converting mm/dd/yyyy to yyyy/mm/dd 6
Splitting dd/mm/yyyy hh:mm 2

Back
Top