Excel Timestamp

[Kaiser]

Good day,

I am trying to convert the timestamp to look like this:
14-Jan-2016 10:48:42.000000

But the time stamp is coming up like this :
14/01/2016 10:48:42 AM or it is coming like 41083 10:48:42 AM

Can you please help me with the formulae or the process that be used for the desired result 14-Jan-2016 10:48:42.000000. Please advise. I have also attached an excel sheet with the example.

Thanking you.

Kaiser

 

[vletm]

@Kaiser
You wrote that 'System Generated'.
Could Your 'System Generate' it at once in wanted format?
or
=TEXT(DATEVALUE(A4);"dd-mmm-yyyy") & " " &TEXT(TIMEVALUE(A4);"hh:mm:ss") & ".000000"
=TEXT(DATEVALUE(A4),"dd-mmm-yyyy") & " " &TEXT(TIMEVALUE(A4),"hh:mm:ss") & ".000000"
(depend Your settings ";" or "," )

 

[Kaiser]

Dear Mr. Vletm,

First I thank you for taking the effort to help me to solve the problem. Actually the system generated report is designed by a Russian company which we cannot change it. So, when we generate the report is comes a text format, then we import to excel and prepare the data. later we need to export as XML which is another tough process. I have tried to use your formula but not working, probably I may be doing some mistake. Sir, can you please provide the solution in the excel sheet that I have attached before. I am attaching the excel file once again for you. Thank you once again for the support. Take care,

 

[vletm]

@Kaiser
Nice to notice that Russian Company uses 'own format' for time.
I gotta modify that formula.
Test please...

 

[Kaiser]

Boss, first when I open the xls, it says do you want to 'Enable Editing", when I click the enable editing, the figure shows as:
It comes as #VALUE as given below: Pls advise.
TRANSACTION_TIMESTAMPTRANSACTION_TIMESTAMP
14/01/2016 10:48:42 AM14-Jan-2016 10:48:42.000000#VALUE!

 

[vletm]

@Kaiser
Interesting ...

This could be the most shortest formula ... for Cell[C4]
if You use ";" then =LEFT(A4;19) & ".000000"
if You use "," then =LEFT(A4,19) & ".000000"
"Russian Tricky afternoon PM- time stamp"