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]