Forum Discussion

Copper Contributor

Jan 25, 2022

Change dataformat from SQL in Excel

Hi. We have a problem converting a time stamp export from SQL 2019. Is there a way to convert it inside Excel (Not in the Database export) to a number. It has the format Year-MM-DD HH:MM:SS,000 like:...

excel

Formulas and Functions

pbjerre

Copper Contributor

Jan 31, 2022

HansVogelaar

Hi. I get this error:

I am not able to upload an xls file

pbjerre

Copper Contributor

Jan 31, 2022

Here is the sample xls file

SergeiBaklan
Diamond Contributor
Jan 31, 2022
pbjerre

Try to apply General format and re-enter.

In my case simple =A2+0 works
- pbjerre
  Copper Contributor
  Feb 01, 2022
  SergeiBaklan
  Hm. It does not work when I press enter in the formular?? I dont see a diffence if I chose General or costum format. What could be the reason?
  - SergeiBaklan
    Diamond Contributor
    Feb 01, 2022
    pbjerre
    
    It depends on you regional settings. Thus use =DATE(...) + TIMEVALUE(...) but remove +0 at the end
HansVogelaar
MVP
Jan 31, 2022
pbjerre

Modified with two possible formulas:
- pbjerre
  Copper Contributor
  Feb 01, 2022
  HansVogelaar
  Yes. Thanks. This worked
  - klamaa
    Copper Contributor
    Sep 29, 2022
    Hi HansVogelaar
    
    I don't have separeted value. My SQL has this value Tue Jan 11 2022 00:00:00 GMT+0100 and I am trying to convert it into date but it is not working. Any advice please?
    
    Best,