ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I increase the lengh of a cell which contains numbers (https://www.excelbanter.com/new-users-excel/243542-how-do-i-increase-lengh-cell-contains-numbers.html)

jakeh

How do I increase the lengh of a cell which contains numbers
 


Gord Dibben

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:



jakeh

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

Gord Dibben

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com