Cathie

Without formulas.

DataText to ColumnsNextNextColumn Data FormatDateYDM and finish.


Gord Dibben MS Excel MVP

On Wed, 2 Aug 2006 11:45:03 -0700, Cathie
wrote:

I have a list of birthdates (ex. 19990901) how do I format this number to
show the birthdate as 1999/09/01 or 01/09/1999. I prefer the latter. Any
help is greatly appreciated.