Link to home
Create AccountLog in
Avatar of zimmer9
zimmer9Flag for United States of America

asked on

Do you know how to modify column A in an Excel 2003 file to display in format mm/dd/yyyy?

I am working on an Excel 2003 file.

Do you know how to modify column A to display in format mm/dd/yyyy
to remove the timestamp?
Supress.xls
Avatar of nand633
nand633

Click the header of column A to select the whole column, then right click the column and select Format Cells in the menu. In Catagory you can change the data type to Date.
Avatar of zimmer9

ASKER

And by doing this, the field value will change from

6/14/2012 10:00:16.353 AM   -->  to this   -->   6/14/2012
Avatar of zimmer9

ASKER

=MONTH(CX1) & "/" & DAY(CX1) & "/" & YEAR(CX1)

How would I modify the above to NOT display anything if the field is blank?
" And by doing this, the field value will change from

6/14/2012 10:00:16.353 AM   -->  to this   -->   6/14/2012 "

Don need a formula or something. If you need a date format which is not in Excel defaultly, simply slect Format Cells and change the number type to Custom.

In the Type field, type mm/dd/yyyy then. That's it.
Avatar of zimmer9

ASKER

I tried changing to Custom & the type field to mm/dd/yyyy but the field remains with the timestamp.
Avatar of zimmer9

ASKER

=MONTH(CX1) & "/" & DAY(CX1) & "/" & YEAR(CX1)

How would I modify the above to NOT display anything if the field is blank?
SOLUTION
Avatar of felixdsouza
felixdsouza
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account