Hi madawa, On Saturday, 2009-12-19 11:00:05 +0530, madawa jeevananda wrote:
> Now, this is done and I need to convert those cells to number cells. > It is possible to convert a number which is formated as text using > parsing methods. When it is parsed to double it works well, as it > behave as a number (It can be subjected to any mathematical function). > But the problem is the type of the cell does not change accordingly. > It remains as text. > > I need to change the type of those cells from text to number. Converting text to numbers automatically may be error prone as it depends on locale dependent separators and/or date order conventions used in the text. Take a look at the Convert Text To Number extension, http://extensions.services.openoffice.org/project/CT2N Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [email protected] account, which I use for mailing lists only and don't read from outside Sun. Use [email protected] Thanks.
pgpkSkOMN75Lo.pgp
Description: PGP signature
