In "Calc" I am attempting to format cell for date. I entered the date in format MM-DD-YYYY. I select "Format-Cell-Date-"December 31, 1999"-OK. The information in the cell is still MM-DD-YYYY, no change. I am also trying this with the brush in the tool bar, with no avail. Am I doing something wrong
When you enter the formatting menu,
Enter your format at the bottom where it says 'format code'.
Check on the green check mark.
To apply this format to other cells, I would use copy, paste special and then unselect every option except for format.
Except you want do the opposite. Hmm...
Asked: 2017-05-29 20:20:05 +0100
Seen: 2,465 times
Last updated: May 29 '17
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Once you have created the user defined format,as shown below, you will be able to change the cell to any of the date formats shown. At the moment it considers the cell as text.