Hi everyone
I have an Excel file with 8 columns
in one of them there is a date (the format of the cells is date, I changed it to date after I tried once but it didnt helped), but for some reason Kryon is getting it as decimal number.
in the first pic its the real dates in the excel file
and in the second the decimal numbers that Kryon gets instead
Please help me I really don't know what to do
In the copy from excel command I think there’s an option to set the format
@דניאל ליכטנשטט I am adding to @darren Cheng 's reply. This is the "Copy from excel" advanced command.
Field #5 is where you can specify the copy method.
When to use Actual Values and when Formatted Text is recommended?
It's important to use the Formatted Text option when the relevant cells are
formatted as dates. Otherwise, the values returned will be the serial numbers for
the dates of the Excel. (For example: June 21, 2017 = serial number 42907)
For reading all other cells, use the Actual Values option.
Note, Formatted Text provides the exact same text as in the excel. To avoid having
fields presented as ####, the columns need to have the proper length - which you
can do directly in the excel or by using Macro. You can also use the Run Macro
advanced command to perform this action. Read more here.
Hello,
Also, review this article:
Kind regards,
Theo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.