On Fri, 2006-06-16 at 16:01 +1000, Royce & Faye Green wrote: > I am using OpenOffice2; Calc. > PROBLEM: > When downloading tables from internet sites into Calc,
When you say "Downloading", what does that mean? Are you downloading an actual file, or copying from a web page (html) table and pasting into Calc? > the format of cells is often all in text, even though they contain > numeric data. > I need to convert this data into number format values, in order to > carry out calculations. > Please tell me if there is a format key or a function I can use to do > this conversion. Select (highlight) the required range, row or column of cells, then right click and select "format cells" from the pop-up menu. You can then define the numeric format for your selection. > Thank you. > > > Kind regards, > Royce Green > > 28 Durran Street > TUGUN QLD 4224 > AUSTRALIA Hope this helps. Dave (TAS) -- This is a mailing list which exists to support users of OpenOffice.org All answers are given by other users who volunteer their time. If you are not subscribed to this mailing list you may not see all the replies to your query. Please reply to [email protected] only and include some indication that you are not subscribed to this list. (eg. "I am not subscribed to this list, please cc me.") For on-line support see: http://support.openoffice.org/index.html For a knowledge base see: http://mindmeld.cybersite.com.au/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
