date formula question

  • Thread starter Thread starter ABASSANETTI
  • Start date Start date
A

ABASSANETTI

Does anyone know how to change the date format in excel to read (ie
20020429 instead of 04/29/2002..... Is there a formula or something
I tried changing the date format and it doesn't have the format
need.... Please hel
 
Right-click the cell you want to change, select the Format Cell dialo
box , then the Number tab, then Custom, enter yyyymmdd then push OK.

HT
 
-----Original Message-----
Does anyone know how to change the date format in excel to read (ie)
20020429 instead of 04/29/2002..... Is there a formula or something?
I tried changing the date format and it doesn't have the format I
need.... Please help


---
Message posted

.
Go to format cells and select custom. In the box under
Click to expand...
Type: type in yyyymmdd.
 
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

Conditional Formating with IF and AND formula 2
Date Format not working 2
Cell showing formula instead of date 6
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
Formula not reading date format 3
converting dates from file 3
Excel Dragging countif formula with changing criteria 3
If formula Date not Blank 2

Back
Top