Formatting Date from imported data

[SL]

Hi~
I have tables that are automatically exported from Access
on a monthly basis into excel spreadsheets-- the tabs are
named after the tables that are imported - data imported
gives monthly dollars figures - when I try to reformat the
months from mm/dd/yy to mmmm - yy it does not format until
I double click on each individual cell. Any way to go
around this without having to click in each individual
cell? Thanks in advance. SL

 

[Bernie Deitrick]

SL,

Insert a new column, format the new column for date, then use a formula like
this in the first row of that column:

=DATEVALUE(E1)

Where E is the column with your imported dates.

HTH,
Bernie
MS Excel MVP