Ask Your Question

in calc 001 instead of 1

asked 2016-12-30 14:41:31 +0200

bendeleider gravatar image

I want to put 001 or something like 0040 in a cell. But I can't get the setting right, so it automatically changes 0040 to 40. Which setting should I change so in the cell will stand 0040?

Thank you ,


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-12-30 14:58:07 +0200

floris v gravatar image

Select the cells that you want to format that way, then right click, Format Cells - and in Format Code enter as many zeroes as you want digits to be displayed. So if you want 00015, 01234, 00004, enter 5 zeroes. In the cells you just enter the numbers, the formatting will take care of the leading zeroes.

See Help on Format Codes.

If this answer helped you, please vote it with ✔ (here on the left). That will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-30 14:41:31 +0200

Seen: 166 times

Last updated: Dec 30 '16