Re: [libreoffice-users] CALC convert text to numbers

For me dealing with an extension, installing it, making sure it doesn't conflict with something 
else was more effort than creating a column, using Value() and then pasting special. 

What's a problem is that in Excel even though it also uses the leading ' to format text as numbers, 
if you change the format of a cell the conversions happen without any problems. I want that same 
behavior in Calc because to me it makes sense that the cell format should be the controlling factor 
for what type of data is in a given cell. 


On Nov 10, 2013, at 7:43 PM, Joel Madero wrote:

> Why is everyone straying away from the fact that there is a simple extension developed by Cor 
> (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to 
> doing these formula techniques instead of just pushing a button on a nice gui

Eugenie (Oogie) McGuire 
Desert Weyr http://www.desertweyr.com/  
Paonia, CO USA


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