Date changes when written to an Excel cell

Help Activities
, ,
1

Hello,

I am trying to write a datetime with a format MMMM yyyy to a cell, but 44986 value is being written instead. I tried changing the cell’s number format before running the robot but it’s still giving me the same output.

image

How can this be fixed?

Thanks a lot!

2

@_pjflo

can you try formatting the cell as text or date format please

Alternately before writing you can append single quote and then write "'" + value

cheers

1 Like
3

Try formatting the cell as text in excel

  1. Select the cell or cells that you want to format as text.
  2. Right-click on the selected cell or cells, and select “Format Cells” from the context menu.
  3. In the “Format Cells” dialog box, select “Text” as the category in the “Number” tab.
  4. Click “OK” to apply the formatting to the selected cells.
4

Thanks a lot for your help!

1 Like
5

Thank you very much! It worked.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.