i working on spreadsheet want have date in format mm/yyyy. have tried using cell formatting date doesn't show desired format. data validation not give me option. assistance appreciated.
this culture issue. cell value typed cell 02/01/2012. in countries when type in digits means jan 2, 2012. in means feb 1, 2012. laptop format , friend has computer foreign format.
the order in type date cell varies country (m/d/yyyy versus d/m/yyyy). set settings in operating system not in excel. excel uses operating system settings determine how interpret type cell.
the format displayed in cell separate issue. controlled in cell formats in excel. can choose whichever format want in excel without affecting underlying value.
Comments
Post a Comment