Question Locked

How do you prevent a 0 from disappearing in a cell in Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm sure everyone has had this problem of that first zero disappearing in a cell in Excel and how to format it to stay. Well how do you make it stay if you are cutting and pasting numbers into a new worksheet from another program? I've tried formating all the cells before and after pasting, etc. but nothing seems to work. Can this be done? And if so, how? These are just a series of 9 numbers all starting with a zero, but we need the zero to show. thanks!

3 replies

by suzanne_juszcyk

Yes, that was the first thing I tried, followed by many others. Actually, since my post someone at work got it. You go to format cells, hit custom, in the type field type in 0 plus ######. The # sign and the zero have to add up to the number of digits in your cell. walla! You would use this on already existing numbers. The text format works if you format first and type your numbers in, but we were not doing that, we needed to copy and paste numbers from another program into Excel. Little tip for anyone coming across the same problem if you are working with 5 digits you can use the zip code format under format cells/special, that works.

This discussion is closed to new replies.