On Jun 25, 2014, at 9:52 AM, Budgie <aje...@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 -- 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