leading zero converting prompt

Maria-A 20 Reputation points
2026-09-10T18:24:14.35+00:00

Good morning, how can I get the prompt back up on excel sheet that ask you if you want to keep the leading zeros? User's image

Microsoft 365 and Office | Excel | Other | Windows
0 comments
Answer accepted by question author
Xavier-D 13,890 Reputation points Microsoft External Staff Moderator
2026-09-11T01:08:40.4766667+00:00

Hello Alcala, Maria

If you previously dismissed the leading-zero prompt, you can review the related setting in Excel:

  1. Select File > Options > Data.
  2. Locate Automatic Data Conversion.
  3. Enable the option that notifies you about automatic data conversions when loading a CSV file or similar data.
  4. Reopen the file to check whether the prompt appears again.

You can also prevent Excel from removing leading zeros by formatting the destination cells as Text before entering or pasting the values.

Please note that the Automatic Data Conversions feature is available in Microsoft 365 and Excel 2024. If you do not see it, let us know which Excel version you are using and whether the data is being typed, pasted, or imported from a CSV file.

I hope this helps you restore the expected behavior.

Feel free reply back to this post if you need further assistance, I'll be happy to help.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.