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!
Sincerely,
William Balderrama
Seideman Law
Creditor Services
Phone (909) 982-5333 Extension 312
Email [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Fax (909) 581-7312
Are the numbers that you're entering actual numerals (like numbers that
have a quantitative meaning)? In other words, numbers that can
realistically be added, or multiplied, or divided? Examples might be
lengths, distances, populations, wavelengths, etc.
Or are they numbers like phone numbers, part numbers, or social security
numbers, which aren't quantitative measures of anything? In other words,
it would make no sense to add two of them together, or divide by 2, or
subtract one from the other.
I'm guessing the later, because it would be highly unusual that you
would need 16 significant figures for anything that has quantitative
meaning. If this is correct (if these numbers are like phone numbers
etc.), then the best thing is to format the cell as "text" BEFORE you
enter the number. (Format > Cells > Numbers > Text) Then I believe
you'll find that the numbers stay as you typed them, as opposed to being
put into scientific notation. At least I just tried this, and it worked
for me.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
