New question on formatting dates from 20090218
I have a column of dates typed as text like +20090218. I've searched this
board for ways to get them into a more readable format such as 2/18/2009.
I've followed everyone's suggestion (and done it on the column as text and as
numbers) and the best I can get is that it comes out as # signs. Usually to
me that means expand the column. When I do that, it's just number signs as
far as I can see.
So far, that's the only way it changes. Usually, it doesn't change at all.
More suggestions would be appreciated?
Bonnie
|