At 15:09 05/04/2007 -0700, Willam Balderrama wrote:
when entering 16 digit numbers on the Open Office Calc, how am I able to cut and paste into cells w/out getting a formula. This happens whenever I enter a lot of digits on one line or try to copy and paste it onto another. I really need your help!
I don't see any reason why you should get a formula. A formula is an expression involving other cell references, and always starts with an equals sign. Is that what you are getting?
Perhaps you have a different problem: that Calc is displaying the result in standard form, so that 1234567890123456 will display as 1.23E+015 instead. This is correct: it means 1.23 multiplied by ten to the power 15, and this form of display is usually helpful. If you want it in another format, you just have to format the cell(s) appropriately.
Select the relevant cells and go to Format | Cells... (or right-click | Format Cells...) and then Numbers. Select "Number" under Category and change the selection under Format from "General" to "-1234" (or whatever is appropriate), and you will get what you need. You may then have to expand the column width to see all those digits, of course.
Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
