On 25/06/14 18:13, Oogie McGuire wrote:
On Jun 25, 2014, at 9:52 AM, Budgie <[email protected]> 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: [email protected]
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
