On Friday 19 August 2005 07:29, + Djoko Harijanto wrote:
> [ MODERATED ] ***********************
> Dear Support,
>
> I have a calc document that have text content, let say '123 and would like
> to convert it to numeric content 123 . I tried to use copy and paste
> special function as it worked before in Microsoft Xl, but it didnt work in
> OO, appreciate your help .TXl
As you are not subscribed you may not have seen that:
On Friday 19 August 2005 23:08, john geldman wrote:
> Interesting function. I hadn't explored it. I just tried it on a
> date, a literal string and a number, and got the "right" value for
> them all.
>
> Maybe it of use to Djoko.
>
> Regards, John
>
> On 8/19/05, David Chapman <[EMAIL PROTECTED]> wrote:
> > Perhaps the VALUE function is something that may be of use to you.
> >
> > It returns the numerical value of a string
> >
> > On 8/19/05, john geldman <[EMAIL PROTECTED]> wrote:
> > > I am just another user (not a guru). YMMV.
> > >
> > > If you have have used the ' literal marker character to make an entry
> > > a string, I think you will have to remove it.
> > >
> > > If the entries are just numbers, but the cells have been formatted as
> > > text then selecting the cells and changing the format should work.
> > >
> > > OpenOffice doesn't have the paste "value" command that takes a
> > > formulas value and pastes it, but the paste "number" appears to do the
> > > same. Notet that this paste function won't remove the ' or literal
> > > marker.
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]
