GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Excel question (https://gfy.com/showthread.php?t=679528)

sickkittens 11-21-2006 02:48 PM

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.

schneemann 11-21-2006 02:51 PM

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.

After Shock Media 11-21-2006 02:51 PM

format cell
category special.

By the way this has a zip code option in special.

sickkittens 11-21-2006 03:14 PM

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