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

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

As so often, Paste Special... is your friend. Copy the results of 
your formula and paste them back - either over themselves or even 
over the original data - but using Paste Special... (or Ctrl+Shift+V) 
instead of ordinary Paste. In the Paste Special dialogue, ensure that 
Paste All is not ticked and then that Formulae is also not ticked.

I trust this helps.

Brian Barker


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