On Sun June 18 2006 15:44, + [EMAIL PROTECTED] wrote:
> I have a spreadsheet that is treating numbers entered, imported from a .dbf
> file, as text, ie the ' is before the number.
>
> How do I convert or format that column so that these are read as numeric
> values so that I can perform math on them.
You can of course remove the ' character before the number, or write a macro
to do this. An alternative is probably to change the definition of your
database so that the number columns are actually defined as being integer (or
float).
Please reply to users@openoffice.org only
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
