![]() |
Excel question
How do I stop cells from automatically dropping a "0" when a number begins with it (0).
i.e. I'm trying to add zip codes and if I put in 01234, it shows as 1234. |
Right-click on the column. Select "format cells", then choose "text". When you choose text, whatever you put in it will remain exactly as you type it.
|
format cell
category special. By the way this has a zip code option in special. |
Thanks. :thumbsup
|
| All times are GMT -7. The time now is 08:29 PM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123