birthdate

Wawaloam · Mar 12th, 2002, 11:27 AM

I am exporting from SASI student database and the birthdates export by yyyy/dd/mm and we need to format the birthdates into mm/dd/yy. We cannot change the birthdates. I have contacted SASI and they say it is an Excel problem.
Any answers?
Wawaloam

Mar 12th, 2002, 12:03 PM

Is the date being imported as text? Try adding another column and using the datevalue() function to convert the string to a date, then format as you like.

NateO · Mar 12th, 2002, 12:07 PM

Or highlight the section, click (menu) Data-> text to columns. Click next. Uncheck all boxes, click next. Choose Data under the column data format, and select the MDY format. Click finish.

Cheers, Nate

Mar 12th, 2002, 12:07 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Or highlight the section, click (menu) Data-> text to columns. Click next. Uncheck all boxes, click next. Choose Data under the column data format, and select the MDY format. Click finish. Cheers, Nate __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 11:27 AM	#1
Wawaloam New Member Join Date: Mar 2002 Location: Judy Posts: 2	I am exporting from SASI student database and the birthdates export by yyyy/dd/mm and we need to format the birthdates into mm/dd/yy. We cannot change the birthdates. I have contacted SASI and they say it is an Excel problem. Any answers? Wawaloam

Mar 12th, 2002, 12:03 PM	#2
Guest Posts: n/a	Is the date being imported as text? Try adding another column and using the datevalue() function to convert the string to a date, then format as you like.