[libreoffice-users] Calc question on dates in formulas

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