Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

What’s Up With The ##### In My Worksheet?

Friday, November 19th, 2004 by | Filed Under: MS Excel
 
Loading...


What’s Up With The ##### In My Worksheet?

Have you ever found yourself happily working in MS Excel only to be befuddled by the sudden appearance of #### in a cell where there should be a number?

Or maybe something along the lines of 2E+15 appeared?

Now what is that?

Good question, and believe it or not, there’s a good answer. (You may not like the answer—but it’s a valid one just the same.)

The deal with the ### is that your number is too long to fit in the cell width you’ve set.

I’ve found that as long as I haven’t previously made manual changes to the cell width it will automatically adjust to a numbers width.

But, if I’ve been messing with the width setting than it just leaves it where it’s set. So, when the number is too long to fit it’s letting you know that by displaying the ###.

And what about the 2E+15 you ask?

Well, that’s your number put into scientific notation.

I find that Excel puts my data into scientific notation if the cell has the default cell format of general and the number is too long for the cell but still long enough to get this in.

If the cell is specifically formatted some other way than you may not see this one, but Excel is trying to display some sort of value and that’s often the shortest way to display a large number.

Looking for a solution to the problem(s)?

Simple – make the cell width larger.

There are many ways you can accomplish this task. A couple of the fastest have to do with the column label letter.

At the top of the column you’ll find the letter label – each letter is separated from the next column by a vertical line.

image

One way to change the column width using this divider is to slowly run your mouse pointer over the divider to the right of the letter. When it turns into a double-sided arrow click the left mouse button and hold it.

Now simply drag the divider to the right and release the mouse button when you feel you’ve made the column wide enough. (You’ll know if it’s big enough immediately – the number will be completely displayed.)

Another way is to get the program to AutoFit to the longest piece of data in the column.

The fastest way to accomplish this is to go back to the column label divider to the right on the column.

This time, instead of the old “click and hold” thing, double-click on the divider.

Instantly you’ll see the column jump to just the right width to accommodate your data.

BTW – you can also change column with Format menu, Column submenu.

image

Manual adjustments can be completed through the Width choice. AutoFit Selection will expand all columns currently selected. If only one cell is selected than it works just on that column.

Whatever your method choice – they all remove the #### blues.

~ April

Leave a Reply


Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: