Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How do I increase the lengh of a cell which contains numbers


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I increase the lengh of a cell which contains numbers

Make the entire column wider.

I won't mention the other option which is to merge a couple of adjacent
cells.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 13:54:03 -0700, jakeh
wrote:


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How do I increase the lengh of a cell which contains numbers



"Gord Dibben" wrote:

Make the entire column wider.

I won't mention the other option which is to merge a couple of adjacent
cells.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 13:54:03 -0700, jakeh
wrote:


Thank you but that really my question.

But would appreciate how to do that.

Jakeh
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I increase the lengh of a cell which contains numbers

I gave you two options.

Which one is "that"?

Wider..............drag the column header wider or FormatColumnAutofit
Selection

Merge cells...................select A1 and B1 and FormatCellsMerge

Or hit the Merge cells Icon on the formatting toolbar.


Gord

On Wed, 23 Sep 2009 21:05:01 -0700, jakeh
wrote:



"Gord Dibben" wrote:

Make the entire column wider.

I won't mention the other option which is to merge a couple of adjacent
cells.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 13:54:03 -0700, jakeh
wrote:


Thank you but that really my question.

But would appreciate how to do that.

Jakeh


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I increase numbers by 10%, 15% and 20%? RMPHELP Excel Discussion (Misc queries) 5 April 15th 10 06:59 PM
vlookup by the lengh Shairal Excel Worksheet Functions 3 August 26th 09 04:50 PM
HOW DO i INCREASE THE NUMBERS IN 1 COLUMN BY 5.5%? ROBINTHEGREAT Excel Discussion (Misc queries) 5 August 11th 08 04:38 PM
Number in cell increase with increase in font size. Value increases with increase in font.[_2_] Excel Discussion (Misc queries) 2 August 9th 07 01:58 PM
How do I increase a column of numbers by a percentage-same cell dcasdos Excel Discussion (Misc queries) 3 June 4th 06 09:21 PM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"