Getting into a muddle here so if anybody could straighten me out it
would be appreciated.
I have several columns in sheet with dates in the format 25 Jun 2014
which have been imported into Calc via a .csv file from another programme.
I have to manipulate the data and then export it as a .csv file for
import by yet another program which requires the dates in the format
25/06/2014.
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.
Please could somebody advise how I should proceed.
--
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
