• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1469
  • Last Modified:

Convert Date to String in Excel 2007

How do I convert a date 03/07/1974 to a string in Excel 2007? I would like to keep the leading zero and just have 03071974 ?
0
fselliott
Asked:
fselliott
1 Solution
 
Saurabh Singh TeotiaCommented:
You can use the following formula...
=text(a1,"mmddyyyy")
Assuming you enter date in A1 in mm/dd/yyyy format.
Saurabh...
0
 
fselliottAuthor Commented:
Worked perfectly!
0
 
JayCommented:
I need to do the exact opposite and I'm stumped.

I have a date string "20091128"  that i need converted into "MM/DD/YY"

In excel I can split the cell into three parts, but can't put it back together in the format i want.

any help would be appreciated!  Thanks!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now