Enter numbers as text / display leading zeros

Enter numbers as text - Display leading zeros

Who in Excel z. E.g. if you enter 001 in a cell, Excel will recognize the entry as a number and only leave a 001 of 1. If you want to enter a number as text and thus want to keep the leading zeros, proceed as follows:


Click in the cell and enter Ellipses

 

(Hold Shift + #) enter and the desired combination of numbers. The edit line now shows the ellipsis followed by the number combination.

 

 

Questions about Office or especially Excel click here.


more interesting Excel tips:

Transparency: This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de.

___________________________________________________
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille

Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.