Formula Advice to convert UK date to a set format

[VBA learner ITG]

Hi Peers,

I thought I was pretty good at managing Date formats in Excel but this one has left me stumped.

I was wondering if you could provide advice on how to convert this date format: 31/08/2020 11:29:34

To the below format which needs to be stored as Text?

2020-08-31 11:29:34 GMT+0000

I can right click and apply a custom format to 2020-08-31 11:29:34 but I need the GMT+0000 within the cell value..

Any advice is appreciated.

 

[jasonb75]

Try

yyyy-mm-dd hh:mm:ss "GMT+0000"

Or if this should be taken as literal

but I need the GMT+0000 within the cell value.

and it needs to be in the cell not just the formatting, it would be easiest to reformat it and join the extra text as a string with vba.

 

[VBA learner ITG]

Try

yyyy-mm-dd hh:mm:ss "GMT+0000"

Or if this should be taken as literal

and it needs to be in the cell not just the formatting, it would be easiest to reformat it and join the extra text as a string with vba.

Thank you for the reply and advice i will definitely do that.