![]() To do so, select the empty cells where you will paste your data later, then open "Format cells" and select "Text". BEFORE pasting your data, preformat the cells as text.Applies to Excel 2013, but might occur in other Excel versions as well. Unfortunately, there is no way to turn this off. This is very frustrating when you enter something that you don't want to be changed to a date. "Microsoft Excel is preprogrammed to make it easier to enter dates. Quote from the official Excel documentation: (There are other formats where this might happen although the number is not a date at all.) While this issue is not directly related to Datawrapper, it's a common and known issue with Excel – which can be frustrating and time-consuming: Excel is trained to "detect" formats, and sometimes the software tends to wrongly assume that a certain number represents a date and changes it. Sometimes importing data into spreadsheets gives you headaches. ![]() ![]() Excel keeps changing my numbers into dates.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |