Convert a date value to "ddmmyyyyhh:mm" format

[offbeatspoiler]

HI all,
I have a excel sheet to convert to notepad. I have a column in this excel sheet which is date (dd/mm/yyyy hh:mm:ss) and upon converting this column to notepad , that column should be in "ddmmyyyyhh:mm" format.
I am not a programmer and don't know the programming code.

Can anyone please help me.



Thanks & regards
Plumban

[pecoflyer]

Hi
as dates can be tricky in XL could you please post a small sample sheet ( no pics please) Thx

[offbeatspoiler]

Thanks pecoflyer for your reply...

I am attaching my excel sheet . In that column E has dates which is of format "dd/mm/yyyy hh:mm:ss". Need to convert it into "ddmmyyyhh:mm".


Thanks & regards
Plumban

[NoSparks]

Without touching or changing anything on your sheet...
Will this work for you ?

[offbeatspoiler]

Thanks NoSparks for your reply.. It worked just fine.


Thanks a lot..



Regards
Plumban