Home › Browse Extensions

Convert Text To Number

by Nou&Off
(0 votes)
TextToNumber_0.png

ConvertTextToNumber replaces numbers that are formatted as text, with real numbers and also marks the cells with a colour. This only on the active sheet. As a result formulas that use such cells, will be calculated in Calc. Calc does not use cells, with numbers formatted as text, in formulas. Other spreadsheet programs may well do that.
This extension adds the tool bar 'CT2N' to Calc.

Download extension
Operating System: System Independent
Official release: 0.9.2
Date: 2008-Feb-14
Size: 20.6 KB
View all releases
License: opensource | Read license
Further product information: Product details
Provider: Nou&Off
Report abuse here | Contact extension owner
  • 5218 downloads initiated

Comments

Thu, 02/21/2008 - 03:57 — sam5588

Text to Column & Column to text

Hi, this is a great extension for OO. But is there any extension can use for column to text?

Fri, 02/29/2008 - 07:10 — cornouws

column to text

Thanks for the compliment.
reg. your question: is it this one from OOoMacro's:
http://www.ooomacros.org/user.php#104183 ?

Pls note that OOo 2.4.0 (RC2 is on it's way) will hold that function.
See the draft info:
http://wiki.services.openoffice.org/wiki/New_Features_2.4#Calc_2

Regards,
Cor

Thu, 02/14/2008 - 11:33 — andisl

Nothing happens

Hi!

I tried this extension on spreadsheet converted from Excel xls file with lot of this kind of numbers - '7,8. But nothing happened. Converter just select all content of the spreadsheet and prints message with empty list of edited cells. Ubuntu 7.10, openoffice.org 2.3.1. Am I doing something wrong?

Andis

Thu, 02/14/2008 - 16:31 — cornouws

Nothing happens

Thanks for your comment, Andis. Was bug that is fixed now in 0.9.2
Cor