Formatting issue.

[Craig1]

Hi Guys,
When I tranfer data into my workbook it always comes in formatted like 20110424. I know I can manually format the column to 24/04/2011 but is there a way of making excel automatically keep the 24/04/2011 format instead of excel changing it to the imported format of 20110424.

Craig.

Just thought I would ask this quick question before I go see the Easter Bunny.

 

[Michael M]

Assuming your date was in column "B"
then
You could also change this to an Autpen macro so that was done everytime you opened the workbook.

SubFormatdate()
    Columns("B:B").NumberFormat = "d/m/yyyy;@"
End Sub

 

[Glory]

If you knew which column you wanted t4o format ahead-of-time, it might be simlper just to format that column in advance, to save yourself the hassle.

Alternatively, a worksheet change event might be the ticket? I don't know whether Excel will convert the date to a serial number before triggering the event or afterward. If it's the former then you might be out of luck.

Excel doesn't have any feature I'm aware of to turn off automatic date recognition, and Google appears to agree.