Home » Microsoft » Excel » 0 ahead for a number in Excel
  1. Home
  2. Knowledge Base
  3. Microsoft
  4. Excel
  5. 0 ahead for a number in Excel

0 ahead for a number in Excel

This small formula helps you to introduce a 0 for single-digit numbers in Excel:

=TEXT(TAG(A1); “00”)

Column A1 contains a date as an example.

Dieser Beitrag ist auch verfügbar auf: Deutsch (German)

Was this article helpful?
Yes No

About The Author


Related Articles

Submit a Comment

Your email address will not be published. Required fields are marked *

Do you need help?

Send team messageSend e-mail
Published on - 7. Jun 2020
Modified on - 1. Apr 2024
Views - 56
Likes - 0

Tags

Do you need help?

Kontaktiere uns gerne :-)
Contact Support
Skip to content