<attout> text Format extracted as date, not text when opening in Excel

<attout> text Format extracted as date, not text when opening in Excel

sharpl
Advocate Advocate
302 Views
4 Replies
Message 1 of 5

<attout> text Format extracted as date, not text when opening in Excel

sharpl
Advocate
Advocate

Anyone knows how to prevent Excel converting "/" into a date format? I need it in a text format, no changes. 

0 Likes
303 Views
4 Replies
Replies (4)
Message 2 of 5

komondormrex
Mentor
Mentor

add apostrophe ahead of "/" date.

0 Likes
Message 3 of 5

sharpl
Advocate
Advocate

I will try this too. I was able to assign the text format to the specific column when opening, it worked.

0 Likes
Message 4 of 5

ec-cad
Collaborator
Collaborator

For output to Excel, you can try wrapping the Date in double quotes.

e.g. (setq date (strcat (chr 34) date (chr 34)))

 

ECCAD

0 Likes
Message 5 of 5

Sea-Haven
Mentor
Mentor

Maybe an easy fix not sure what your text looks like if "10/10/2025" then just use "'10/10/2025" ie add a single quote at start Excel will then work properly. Can you post what the text looks like.

0 Likes