Re: [libreoffice-users] Calc question on dates in formulas

On 25/06/14 18:13, Oogie McGuire wrote:
> On Jun 25, 2014, at 9:52 AM, Budgie <ajebay@errichel.co.uk> wrote:
>
> > I have been able to create a column with the dates in required format using the formula 
> > =TEXT(B2,"DD/MM/YYYY") but this leaves the underlying formula in the cell so when I try and remove unwanted 
> > columns the formula fails.  What I need is the date as written by the formula "frozen" as text so I may then 
> > manipulate the columns without messing up.  Hope this is clear.
>
> Once you create your column with the date formatted properly copy it and paste special into a new 
> column including only the text or numbers.
>
>
> Eugenie (Oogie) McGuire
> Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/
> LambTracker - Open Source SW for Shepherds http://www.lambtracker.com
> Paonia, CO USA
Many thanks Eugenie, I have it now but got there a long way round.

I was very interested in the sheep links and your farming objectives, 
which we share.  We do not have rare sheep at present although we have a 
few sheep and the tagging looks interesting.  We also have a few 
Shetland cattle, which are rare, and have just completed small extension 
to the farmhouse for a commercial kitchen so we can open restaurant.

Thanks again for your help.
Regards,
Alastair.

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