I need to convert a column of numbers to a date format

[How do I set up a repeating meeting in A]

Hi,

I need help converting a column of numbers to a date format.

Example: 19991120 need to convert to 11/20/1999

Please help!

Thank you,
Bruce

 

[JE McGimpsey]

How do I set up a repeating meeting in A

Hi,

I need help converting a column of numbers to a date format.

Example: 19991120 need to convert to 11/20/1999

One way:

Data/Text to Columns. Click Next, Next, then select YMD in the Date
dropdown. Click Finish.

Format as you wish.

 

[How do I set up a repeating meeting in A]

Thank you SO MUCH!

took less than 1 minute you rock!!