I have a spreadsheet to keep track of payments. In one column I will type 'ctrl+;' to enter the date. These cells are formatted for date and duly show the date. If a date is entered the amount received will appear in the adjacent cell (the amount is the same for everyone, so it's part of the cell formula). On a separate sheet I keep track of payments due. These cells check for entries in the 'Date' column. If the 'Date' column cell is blank, they show amount due (requiring 'number/currency' formatting); if there is an entry in the 'Date' column cell (ie. there has been a payment) I want the cell to show the date from the 'Date' column. However, because the cells are formatted for 'number/currency' I get a number. Under formulas we have dateValue(). What is the opposite of that? Why isn't there a dateText() formula? What am I missing? -- View this message in context: http://nabble.documentfoundation.org/dateValue-to-dateText-tp4121333.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted