Bomasterflex24
New Member
- Joined
- Feb 1, 2019
- Messages
- 6
I have a dataset exported from another database, ADP, Smartsheet or something. The entire workbook cells are stored as text however, the cell format still says "General".
I have tried to change the cell format around but the change is not detected, as verified by using functions like ISTEXT and ISNUMBER.
I should not have to copy the entire workbook and paste "as values" and then go column by column adjusting the formats as text, number, time, date.
The issue is that anything I write will appear as the proper "General" format but even when I change it to "Text" Excel still does not recognize the cell as text.
Pictures posted below
I have tried to change the cell format around but the change is not detected, as verified by using functions like ISTEXT and ISNUMBER.
I should not have to copy the entire workbook and paste "as values" and then go column by column adjusting the formats as text, number, time, date.
The issue is that anything I write will appear as the proper "General" format but even when I change it to "Text" Excel still does not recognize the cell as text.
Pictures posted below