In the excel table, 0 in the date 12.10 does not show what is going on?

11 Answers

1. +7Votes  

   When you directly enter “12.10” in the cell, Excel does not treat the number you enter as a date, but treat it as a numerical value.

   To enter the date, you should enter it in the date format: 12-10

   The separator should use the bar, don’t use the decimal point!

   Walter Thompson- November 23, 2018 |

2. +1Votes  

   May 1: Your cell format is not set at all: then 12.10 is a regular number, naturally it will show 12.1

   Maybe 2: You set the format, but the cell Not enough length: just increase the cell width to increase

   possible 3: cell setting–number–date–select 3-14 type

   Jennifer Roberts- November 24, 2018 |

3. +3Votes  

   format, Keep two decimals

   Janet- November 25, 2018 |

4. +2Votes  

   The date should be entered as:

   12-10

   with a minus sign – No decimal point.

   Susan- November 25, 2018 |

5. +7Votes  

   It is not possible to enter 12.10 directly. Add the year. Such as: 2017.12.10

   Betty Lee- November 25, 2018 |

6. +2Votes  

   Change to date or text format

   Patrick Jones- November 25, 2018 |

7. +1Votes  

   Requires formatting

   Pamela- November 26, 2018 |

8. +1Votes  

   The cell format does not have a date format set.

   Angela King- November 27, 2018 |

9. +4Votes  

   Change the cell format to a date

   Mark Wright- November 27, 2018 |

10. +6Votes  

    The date format is incorrect

    Arthur Hill- November 27, 2018 |

11. +4Votes  

    may be due to the small size of the gap in the table. It is recommended to lengthen and enlarge one point and it will be displayed.

    Brenda Lee- November 27, 2018 |