I have an issue with Excel as a spreadsheet for my Appsheet app. It seems like Excel really wants to guess what kind of data I have and format it as such. Unfortunately it happens to guess wrong sometimes.
I have a “location” column in my app which is formatted as:
[Row] - [Number] - [Floor]
For instance a location could be “1-1-1”.
Unfortunately when this syncs to Excel, it thinks it’s a date so instead of keeping it as “1-1-1” it changes it to “01-01-2001 00:00:00” which obviously makes no sense for a location.
Is there any way to prevent this? I know Excel has formatting options, but these always seem to revert back to their default setting so I’m out of luck there. In Appsheet the column is selected as “Text” and I could also select that in Excel, but as I said, after a while it changes it back to “General” which then turns it into a date, so is there any other way to prevent this formatting?
Thanks in advance
Here are some pictures that shows the issue:
Excel sheet: The last column (5) is a concatenation of column 2, 3 and 4. Column 1 is just an ID.