Re: [libreoffice-users] Calc: Inline Formatting

That sounds like what I was looking for.  I'll play with it later. 
Thanks much!

Dave


On 1/24/2014 17:02, Brian Barker wrote:
> 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+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