+ Reply to Thread
Results 1 to 2 of 2

Excel Format

  1. #1
    Registered User
    Join Date
    01-18-2005
    Posts
    62

    Excel Format

    Dear all,

    I have a problem with format

    In cell A1, I enter 'Happy birthday' I can see it.
    In cell A2, I enter 13000000 I only #####.

    I want to keep the with of this cell unchanged because if I change the width of this cell the other part of whole form is affected.

    Could any one help me how to format A2 to see the whole number or what I enter. See the attchment

    Thanks,

    Nam
    Attached Files Attached Files

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon lehainam

    Quote Originally Posted by lehainam
    I want to keep the with of this cell unchanged
    You can't.
    If a value is too long for a cell, then the "####" are shown to make it obvious that the whole value can not be shown. Can you imagine the mistakes that would be made if people thought a cell said 1,000 when it really said 1,000,000,000 and it just happened that the cell wasn't wide enough?

    HTH

    DominicB

    Edit : Unless you want to prefix the number with a ' and turn it into text - you just won't be able to do any calculations with it.
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1