Output from "Read cell" from excel not displaying the correct content

Hi

I need some help. I have used “read cell” to read the excel cell for “27 Aug” which is a formularised cell = output as a variable. Thereafter, I used “type into” with input as that variable, however, the result was “27 Dec”???

What is happening? I tried to change the format in my excel to date format, text format, general format but the results output for my “type into” still shows 27 Dec.

Fine
can i have a view on the sequence been used may be a screenshot if possible
and also the property panel of write cell activity
Cheers @Chiwfoong

It will retrieve the date in full format @Chiwfoong , but won’t change the date

Can you check with a message box after retrieving the value from excel

Read cell into output Var: ClosingdateEmail

Typeinto based on Var: per above

Excel cell Q3 formula which shows “27 Aug”
Capture3-excel%20formula%20for%20cell%20Q3

However, the output from “Typeinto” shows “27 Dec”.

Thanks for helping!

1 Like

I tried to retrieve the value, it shows 27 Dec instead of 27 Aug. Its so puzzling.

Fine
enable PRESERVE FORMAT check box in READ CELL and try once
Cheers @Chiwfoong

Can you post the format of cell in excel @Chiwfoong?

It’s still showing 27 Dec.

1 Like

May I know what is the value of Q2
@Chiwfoong

This is the Q2 value and its in text format. the cell is showing “27 Aug” based on the excel formula.

Capture4-Q2%20value