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/) but this leaves the underlying formula in
the cell so when I try and remove unwanted columns the formula fails. What
At 16:52 25/06/2014 +0100, Budgie Noname wrote:
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
On Wednesday, June 25, 2014 04:52:24 PM Budgie wrote:
25 Jun 2014
Not sure about openoffice but in LibreOffice you can start calc, go to
Format --Cells -- Date and create a format like you want by inserting
in the Format Code box what you want:
Example: DD/MM/ this will give 25/06/2014.
On 25/06/14 18:13, Oogie McGuire wrote:
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/) but this leaves the underlying formula in the cell so when I try
and remove