|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

VARCHAR from Wdata being formatted as a Date

Zamów wersję demonstracyjną

I'm trying to format my data to be "Number / Number". 

It works when I run the query, but when I connect it to the spreadsheet, the spreadsheet formats it as a date and when I try to change the format to text it gives me the date code. 

What can I do to stop this from happening?

0

Komentarze

Komentarze: 1

Data Głosy
  • Jeff Hickey

    Hi Morgan, I believe what is happening is that the Spreadsheet is attempting to automatically format 11 / 14. You can see the cell format by right clicking on the cell and selecting Cell Properties (or locate it in the Properties panel on the far right). If you enter 11 / 14 into a cell that is set to attempt to automatically format the value, it will automatically think it is a date. If you were to manually switch the format to text, it would display at "45244".

    A possible fix to prevent the cell from formatting it and allow it to display as "11 / 14" is to include an apostrophe at the beginning so that it looks like '11 / 14.

    0

Zaloguj się, aby dodać komentarz.