The date of the Excel table display problems
Users questions: I ask my date of birth and Excel tables are set up to work in text format, such as born in November 1963, as more content, I would enter is 63.11, but both display and print out only 63, behind of. and 11 do not show nor print, this is how What happened?
Experts answer: if you enter 63.11, Excel should it be interpreted as numbers, you look at the cell formatting settings, is not a multiple of the value of the decimal point was set to 0. PS: Enter the date format is best to use a slash "*" or dash "-" as the connectors, which Kind of system will be directly identified.