Re: [libreoffice-users] dateValue() to dateText()?

I have never tried conditional formatting, but, it may apply, sorry I 
don't have time to investigate further, but, hopefully it helps.

https://help.libreoffice.org/Calc/Conditional_Formatting



On 09/05/2014 11:04 PM, Ross wrote:
> 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.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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