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

I just tried this extension. It's easy to use and seems to 
work very well.

Is there a way to move its icon to a different place on the 
tool bar?

Thanks,
-Bill

On 11/10/2013 5:08 PM, Joel Madero wrote:
> http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates 
>
>
>
> That extension should do the trick - we're trying to 
> incorporate it into the core code but so far you need the 
> extension.
>
>
> All the best,
> Joel
>
>
> On 11/10/2013 01:57 PM, Oogie McGuire wrote:
> > I have a spreadsheet that is the output of a SQLite 
> > Database on Android. It contains numbers that have been 
> > formatted as text. When I copy the columns into my 
> > LibreOffice Spreadsheet I want to make sure that they are 
> > interpreted as numbers.
> >
> > However they come in as text and the manuals and help at 
> > Libre Office are less than useful.
> >
> > https://help.libreoffice.org/Calc/Converting_Text_to_Numbers 
> > implies that this conversion happens automatically but it 
> > sure doesn't
> >
> > I found reference to a value function, but no information 
> > on how to apply it to this data.
> >
> >   I tried just changing the format of the cells to be 
> > number but that didn't do anything at all.
> >
> > I've also attempted various styles of paste special but 
> > still it doesn't work.
> >
> > There has got to be a way to quickly say this text is all 
> > really numbers and get it working!
> >
> > Please help
> >
> > 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