Error cell excel

Not applicable

Hi everyone!

 I have following problem which I don't know how to fix it: into a cell I introduce following text: 02:01. I save the file containing this cell, close and reopen it later. This time, instead of 02:01 appeared: 0,0840277777777778 or something like that! This happened with many similar cells! How to automatically restore the value: 02:01 and other similar values ? 

7 Replies





Excel read this "02:01" as a time value.

And when you format the cell that contains this value as General, it shows up as 0.0840277777777778.

The reason for this is that times in Excel are really decimal fractions.


So what's happens to your worksheet is that the cells that contain these time values are formatted somehow as General.

To switch it back, you need to format them as Time as the below screenshot:

Time Format.png


Or you can customize the format to show up exactly as you want by pressing Ctrl+1, then go to Time and choose the format that you prefer, or go to Custom and in the Type box, type this format hh:mm or something similar.




Thank you for your kind support!

It didn"t help at all. I have followed all the mentioned steps but it didn't recover any text with the following form: ##-##.  What else should be done?@Haytham Amairah 




Could you provide the worksheet that you're working on or a sample of it to figure out the problem?


Sure, @Haytham Amairah 


It constains just a few data because I have observed that many issues previous described appeared!




The problem is in the decimal symbol!

It's doesn't match the default the decimal symbol in the OS.

The default is the period (.) as the below screenshot:

Decimal Symbol.png


FYI, Excel depends on the default number formats in the OS.


You can either change the default setting or replace the commas with periods in your worksheet using Find and Replace.

But it's recommended to leave the default setting as is.


After that, you can use the method I mentioned earlier.

But when use the find and replace, you may see the decimals show up like this: 1900-01-00

That's because the data are currently pre-formatted as Data.


Anyway, I've fixed them in the attached file.




Thank you very much. You have saved my day@Haytham Amairah 


@Deleted Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Related Conversations
Search for multiple values
JKLOSS48 in Excel on
0 Replies
Expansion and interpolation of dated dated
Happy-Hoppy in Excel on
0 Replies
average formula
teacher_rich in Excel on
4 Replies
Excel 365 - Extracting non-empty values from a row of values?
AC626 in Excel on
4 Replies
Excel ALT+ENTER - did this go away?
MashPotatoes in Excel on
11 Replies
excel se cierra
garciamuriel in Excel on
0 Replies