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. > > > > > > Regards, > > John > > > > On 8/18/05, Djoko Harijanto <[EMAIL PROTECTED]> wrote: > > > 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 > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > -- > My OpenOffice Calc Website > http://www.openofficetips.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
