Reformat date field to plain text
Closed
Bunk
-
Oct 15, 2017 at 03:57 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Oct 15, 2017 at 10:49 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Oct 15, 2017 at 10:49 PM
Related:
- Reformat date field to plain text
- How to reformat hp laptop - Guide
- How to reformat dell laptop - Guide
- How to reformat windows 7 - Guide
- Reformat asus laptop - Guide
- Reformat external hard drive mac - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Updated on Oct 15, 2017 at 10:51 PM
Updated on Oct 15, 2017 at 10:51 PM
Hello Bunk,
The default formatting for any new excel sheet is "General". Excel will then consider a dash (-) as being associated with dates and will thus format a cell as Date or Custom. You can re-format the column in question as text but it needs to be re-formatted before any data is entered or pasted into the column.
To test this method, open a blank excel worksheet and select any entire column ( just click on any letter above the column to completely high-light it). You will see that in the Home tab, numbers group, the formatting is set to "General".
Right click within the column and select "Format Cells" from the menu that appears. In the dialogue box that then appears, select "Text" from the category list. Click OK. Type in a few of your numbers to test.
Your numbers should then stay as is.
I hope that this helps.
Cheerio,
vcoolio.
The default formatting for any new excel sheet is "General". Excel will then consider a dash (-) as being associated with dates and will thus format a cell as Date or Custom. You can re-format the column in question as text but it needs to be re-formatted before any data is entered or pasted into the column.
To test this method, open a blank excel worksheet and select any entire column ( just click on any letter above the column to completely high-light it). You will see that in the Home tab, numbers group, the formatting is set to "General".
Right click within the column and select "Format Cells" from the menu that appears. In the dialogue box that then appears, select "Text" from the category list. Click OK. Type in a few of your numbers to test.
Your numbers should then stay as is.
I hope that this helps.
Cheerio,
vcoolio.
