Bug in Text type and LongText type

richnegy
Participant I

I set a field to type Text and when I typed in “Monday 7/2”, it would save as number, in this case, the number was 44014. I changed the type of the field to LongText and it saved the number. Is there any reason why it is giving me this strange number?

0 2 141
2 REPLIES 2

Steve
Participant V

Make sure the spreadsheet column format is plain text.

richnegy
Participant I

Thank you so much. I appreciate it!

Top Labels in this Space