OpenOffice Help?!??!?

Question

okay im using Openoffice.org Calc (its like excel from microsoft) and i cant figure out how to get openoffice to let me enter a value of 0000000000 (8 zero's) into a box, everytime i do this it changes it to a 0, can someone help me with this please?

i need 8 zero's because i am making a decimal to binary calculator for a class project, actually i only need to know how to allow 7 zero's and a one 00000001 but i have tried that and it gets rid of all the zeros

i got it i changed the format of the box to text thanks everyone

Answer 1

'00000000

note the ' apostrophe
Or format the cell

Answer 2

I am not familiar with calc as well as Excel, but in excel you have to format the cell as something other than number, if it's a number 0000000000000000000000000 would be 0

So to display it as 0000000000 use the text option, in excel you would use the format cell option and then you would select text. There must be an option in calc where you format cells, try right clicking on the cell and changing to text. But remember you will input the 00000000 after you've changed it to text

Answer 3

Click with the right mouse button on the box (cell). Choose Format Cells. Where it says Leading Zeroes, change the number to 8. Click OK.

Answer 4

8*0=0 , one zero or many zeros are equal to a zero!
in Openoffice there is that function.

if you realy need to insert exactly more zeros and you want to show it, you can change the format of cell or use this rule:

"00000000" <- dont forget (" ")

Answer 5

On the toolbar, there should be a "Format" option, I don't know how Open office works, but in excel, you would go to the numbers tab and pick "text".

Hope that helps!

Answer 6

Change the cell type.