How to change the format in excel?

[christinad_costa]

Hi,

I have column A1 as 9/8/2012 11:00:00 AM. I would like to change it in the specific format as DD.MM.YYYY HH:MM, so I want it to read as exactly this way 08.09.2012 11:00.

I have tried many different ways but its not helping I tried breaking the format as separate date and time n then joining back still no help as when i delete columns A and B its a total disaster.

I simply want the DD.MM.YYYY HH:MM format

Please help

 

[Dryver14]

in the format custom type

dd.mm.yyyy hh:mm

 

[christinad_costa]

The changes happen in the cell thank you for that, however in the formula bar it still shows as 9/8/2012 11:00:00 AM can this be changed to 08.09.2012 11:00 only.

Please

 

[Jonmo1]

Short answer is No.

What is in the formula bar is how Excel sees date/time values. It can't be changed.
That's the purpose for formatting cells, so the Cell "Displays" those values in your desired format.

 

[christinad_costa]

Thank You Dryver14 and Jonmo1

 

[MGORIYA]

Try this...
Write below formula to the adjucent cell..
=TEXT(E2,"dd.mm.yyyy hh:mm")
then copy formula and paste special --> value...