+ Reply to Thread
Results 1 to 2 of 2

Excel Format

  1. #1
    Registered User
    Join Date

    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


    Attached Files Attached Files

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365


    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?



    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)


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