Exported data from Access won't format

  • Thread starter Thread starter bert
  • Start date Start date
B

bert

I have used the Text to Column feature, but the date
column that I have imported into Excel is still in a funky
text format. Will not allow me to change it. Any idea?
 
inserting a column next to the date and multipling by one then formatting as
date may work

if not try the following macro - select the date cells and run the macro.
if none of these work give me an example of the date format ou have as you
can usually alter the macro to get excel to pick up dates properly

Sub FixCells()
Dim cell As Range
For Each cell In Selection
cell.Value = cell.Value
Next cell
End Sub
 
Back
Top