Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Forums
Blogs
Articles
Groups
Galleries
Member List
Calendar
Home
Forum
Simply Business
Fucking Around & Business Discussion
Excel question
Excel question
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
sickkittens
I am a meat popsicle.
Join Date:
Jul 2002
Posts:
25100
Share
Post
#1
Excel question
11-21-2006, 12:48 PM
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.
HIGHEST PAYOUTS FOR NO-CONSOLE TOURS IN THE ENTIRE INDUSTRY!
THIS SIG CAN BE YOURS FOR
$200
- ICQ: 78881543
schneemann
Confirmed User
Join Date:
Oct 2006
Posts:
749
Share
Post
#2
11-21-2006, 12: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.
Deranged World
Comment
Post
Cancel
After Shock Media
It's coming look busy
Join Date:
Mar 2001
Posts:
35299
Share
Post
#3
11-21-2006, 12:51 PM
format cell
category special.
By the way this has a zip code option in special.
[email protected]
ICQ:135982156 AIM: Aftershockmed1a MSN:
[email protected]
Comment
Post
Cancel
sickkittens
I am a meat popsicle.
Join Date:
Jul 2002
Posts:
25100
Share
Post
#4
11-21-2006, 01:14 PM
Thanks.
HIGHEST PAYOUTS FOR NO-CONSOLE TOURS IN THE ENTIRE INDUSTRY!
THIS SIG CAN BE YOURS FOR
$200
- ICQ: 78881543
Comment
Post
Cancel
Previous
template
Next
Working...
OK
OK
Cancel
😀
😂
🥰
😘
🤢
😎
😞
😡
👍
👎
☕
Comment