'View CSV file date as raw string in Excel
I have a CSV file which has time column and its values are String in dd MMM HH:mm format.
Name,Time
Farms,20 Dec 14:00
When I open the CSV file with Excel, Excel automatically converts these Timevalues to date format, thereby modifying to add year value on its own. So 20 Dec 14:00 is converted to 20/12/22 14:00.
What I want is that Excel should display the time column values as raw string, i,e. 20 Dec 14:00.
Some similar questions, suggetsed to modify the CSV file by adding = symbol before the time column values, so that excel treat it as string. But this is not what I want.
I don't want to make any changes to CSV file, but want a way by making some changes in Excel itself.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|