Reformat date field to plain text [Closed]

Report
-
Posts
1285
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
April 10, 2021
-
I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would appreciate some help reformatting. The incoming column contains a set of hyphenated numbers; i. e. 14-10, 14-11, 12-11. Range of the numbers is 10 to 14 and they are test scores. When I paste the web spreadsheet into my local Excel this column is automatically changed to 14-Oct, 14-Nov, 12-Nov. I recognize that Excel thinks these are dates. I have tried all (?) the combinations of formats but I haven’t found a way to reformat the data to its original format of digits-digits. Your help will be greatly appreciated!

1 reply

Posts
1285
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
April 10, 2021
224
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!