Ask Your Question

How do I make 0001, stay like that and not turn into a 1???

asked 2016-10-14 19:34:03 +0100

Jannariina gravatar image

Hi... I do some accounting and made a chart for it, with the writer. Well it need some number like 0001 and IT CHANGES THE INTO 1 AND 2 AND SO ON... I'm so annoyed, because it has to stay in the form 0001. So if you could please tell me how to do that I would appreciate it.

Very annoyed student

edit retag flag offensive close merge delete


Could you add an example that shows your problem, I voted your question so you should now be able to edit your question and attach an example document.

mark_t gravatar imagemark_t ( 2016-10-14 20:08:25 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-10-14 19:46:29 +0100

Blanksheet gravatar image

If this is in a table then the cell format will have to be "number". You can then configure it to have the leading "0" you want.

Do a test page so you can experiment. Insert table, right click cell and select format number. That should get you started.

edit flag offensive delete link more

answered 2016-10-14 20:06:52 +0100

erAck gravatar image

If you expect the content to be a text string instead of numeric value then prepend the input with ' a single quote character. Either that, or preformat the cell to Text (Format->Cells->Numbers) before input.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-14 19:34:03 +0100

Seen: 198 times

Last updated: Oct 14 '16