At 12:33 24/01/2014 -0800, Dave Liesse wrote:
Two simple questions which should be available through Help, but I
haven't been able to find anything.
1. Is there a way to format content within a formula? I need a
cell that concatenates a properly-formatted date to some text, but I
can't find any way to specify the date format.
2. In conjunction with #1, is there a function to return an entire
date in external format rather than having to get the month, day,
and year separately? All I've found is a way to convert a human
date to an internal date.
The TEXT() function is your friend.
I build the cell formula as
=CONCATENATE("my text",$r$2)
... what I really want is MM/DD/YYYY.
Any ideas how to simplify this?
="my text "&TEXT(R2;"MM/DD/YYYY")
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@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
