{"id":1953,"date":"2022-08-07T09:53:35","date_gmt":"2022-08-07T06:53:35","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=204565https:\/\/www.addictivetips.com\/microsoft-office\/stop-numbers-converting-to-date-in-ms-excel\/"},"modified":"2022-08-07T09:53:35","modified_gmt":"2022-08-07T06:53:35","slug":"how-to-stop-numbers-converting-to-date-in-ms-excel","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1953-how-to-stop-numbers-converting-to-date-in-ms-excel\/","title":{"rendered":"How To Stop Numbers Converting To Date In MS Excel"},"content":{"rendered":"

MS Excel is an exceptionally intelligent spreadsheet app and it\u2019s not just because it supports a lot of logical arguments. The app can recognize data for what it is, e.g. it knows when it\u2019s dealing with currency, and when it\u2019s dealing with time values. It\u2019s precisely because of this that many of the functions and formulas in MS Excel are so useful. They don\u2019t just add and subtract numbers but can also be applied to time and currency. This feature is by all accounts useful until it starts incorrectly identifying data. Sometimes, MS Excel will recognize data that isn\u2019t a date as just that. It changes the value in a cell and impacts the formulas you apply. The only way to deal with it is to stop numbers converting to date.<\/p>\n

This happens mostly when you enter alphanumeric values in a particular format but isn\u2019t limited to just that.\u00a0For example, if you write 02-02 in a cell, t will automatically be recognized as February 2nd. The cell will then recognize all data you enter in it as a date or time value.<\/p>\n

\"\"<\/span><\/p>\n

The formulas you apply to the cell are subsequently affected because they aren\u2019t dealing with numbers. Instead, they\u2019re dealing with an entirely different type of data. The solution to this problem is oddly simple.<\/p>\n

First, select the cell with the incorrectly identified data. If you look at the dropdown in the \u2018Number\u2019 toolbox, it reads \u2018Custom\u2019. It doesn\u2019t even read \u2018Date\u2019 or \u2018Time\u2019, and this is what the problem stems from.<\/p>\n

\"\"<\/span><\/p>\n

Open this dropdown and select the \u2018Text\u2019 option. The data you entered in the cell will change into a number. It\u2019s the equivalent of the date that Excel recognized. Delete the figure you see and enter your original data again. This time, with the cell set to recognize everything as \u2018Text\u2019, it will not convert to a date or time, or anything else.<\/p>\n

\"\"<\/span><\/p>\n

This doesn\u2019t solve every problem you might face with the data in the cell. When you apply a formula to the cell, the data is still recognized as a date except, Excel converts it to the numerical value for that date. The formula you apply isn\u2019t going to give you an accurate value. There\u2019s no easy way around this and you will likely have to reformat the way you select values in your formula, or change how you enter them in a cell.<\/p>\n

There\u2019s a lot of trial and error involved here if you have to apply a formula however, if you\u2019re only concerned with presenting data, setting the cell to recognize data as text will do the trick. This setting will persist no matter which device you view the sheet on.<\/p>\n","protected":false},"excerpt":{"rendered":"

MS Excel is an exceptionally intelligent spreadsheet app and it\u2019s not just because it supports a lot of logical arguments. The app can recognize data for what it is, e.g. it knows when it\u2019s dealing with currency, and when it\u2019s dealing with time values. It\u2019s precisely because of this that many of the functions and …<\/p>\n","protected":false},"author":1,"featured_media":1954,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1953"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1953"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1953\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1954"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}