Help: Excel automatically converts numbers into Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2444137%22%20slang%3D%22en-US%22%3EHelp%3A%20Excel%20automatically%20converts%20numbers%20into%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444137%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20would%20really%20appreciate%20it%20if%20someone%20could%20help%20me%20solve%20this%20problem%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20data%20for%20temperatures%20in%20an%20excel%20table%2C%20but%20somehow%20the%20numbers%20are%20being%20converted%20into%20dates%20(e.g.%2025%2C5%20degree%20Celsius%20will%20be%20converted%20into%20May%2025th%2C%20so%20everytime%20there%20was%20half%20a%20degree%20%22____%2C5%22%2C%20excel%20interprets%20this%20as%20a%20data%20and%20thinks%20it%20must%20be%20in%20May).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20alreasy%20tried%20to%20format%20it%20as%20numbers%20(using%20CONTROL%20%2B1)%2C%20but%20then%20the%20cells%20that%20were%20misinterpreted%20as%20days%20do%20still%20not%20get%20corrected%20but%20are%20now%20all%20displayed%20as%20the%20same%20long%20random%20number%20(e.g.%2044345).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20something%20that%20is%20wrongfully%20diplayed%20as%20the%2029th%20of%20May%2C%20and%20that%20is%20supposed%20to%20be%20a%20temperature%20in%20degrees%20celsius%20(likely%2029%2C5)%2C%20then%20becomes%20a%20weird%20number%20such%20as%2044345.%20All%20cells%20that%20have%20a%20round%20number%20do%20not%20get%20converted%20to%20a%20date%20in%20May.%20But%20if%20I%20try%20to%20reformat%20the%20weird%20cells%20as%20%22standard%22%20or%20as%20%22numbers%22%20all%20of%20the%20cells%20that%20were%20wrong%20all%20become%20the%20same%205-digit%20number.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20have%20an%20idea%20why%20this%20is%20happening%20and%20how%20I%20could%20display%20the%20temperatures%3F%20That%20would%20really%20help%20me%20a%20lot%20and%20make%20my%20life%20easier%20as%20correcting%20it%20manually%20would%20take%20too%20long.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2444137%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2444189%22%20slang%3D%22en-US%22%3ERe%3A%20Help%3A%20Excel%20automatically%20converts%20numbers%20into%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1078296%22%20target%3D%22_blank%22%3E%40Isabelle125%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20the%20Short%20Date%20format%20on%20your%20computer%3F%20Does%20it%20happen%20to%20use%20comma%20to%20separate%20day%2C%20month%20and%20year%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I would really appreciate it if someone could help me solve this problem:

 

I have data for temperatures in an excel table, but somehow the numbers are being converted into dates (e.g. 25,5 degree Celsius will be converted into May 25th, so everytime there was half a degree "____,5", excel interprets this as a data and thinks it must be in May). 

 

I alreasy tried to format it as numbers (using CONTROL +1), but then the cells that were misinterpreted as days do still not get corrected but are now all displayed as the same long random number (e.g. 44345). 

 

So something that is wrongfully diplayed as the 29th of May, and that is supposed to be a temperature in degrees celsius (likely 29,5), then becomes a weird number such as 44345. All cells that have a round number do not get converted to a date in May. But if I try to reformat the weird cells as "standard" or as "numbers" all of the cells that were wrong all become the same 5-digit number. 

 

Does anybody have an idea why this is happening and how I could display the temperatures? That would really help me a lot and make my life easier as correcting it manually would take too long. 

 

Thank you for your help!

1 Reply

@Isabelle125 

What is the Short Date format on your computer? Does it happen to use comma to separate day, month and year?