Results 1 to 4 of 4

Thread: Define the format of a cell in excel 2003

  1. #1
    Join Date
    Aug 2009
    Posts
    25

    Define the format of a cell in excel 2003

    I have a table of data on employee in excel 2003, I would like to predefine the format for entering my cell or at least an entire range of cell (column). For example, when I write a bank account number, I would not have to enter dashes 001-5555555-56 but unable to enter the numbers and format, No account is registered automatically. Same for the phone number... Thank you for your help.

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    Re: Define the format of a cell in excel 2003

    For example, you should go to format cells, number tab, custom and data fit into the "type" ###-#######-##, in this line you will have more to type the number without dashes, they'll automatically save.

  3. #3
    Join Date
    Dec 2008
    Posts
    371

    Re: Define the format of a cell in excel 2003

    Defining cell names in Excel is done by highlighting the cell, going to insert on the menu and selecting name and define. Cell is formatted as number. There is no formula applied to the cell(s).Go to the Format Menu and select Cells. Click on the Number tab and select Custom from the list. You can see all the different custom formats Excel offers.

  4. #4
    Join Date
    May 2008
    Posts
    4,348

    Re: Define the format of a cell in excel 2003

    Open Microsoft Excel 2003, then open the file you want to change. Select the cells you want to format.Open the Format menu and select Cells.Click the Number tab.Select a format type from the Category list. For example, for items in a budget, select Currency or Accounting.

Similar Threads

  1. How to display content of cell in a text box Excel 2003 VBA
    By !Jumala! in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 01:03 PM
  2. Excel 2003 file format s not properly specified
    By YajasK in forum MS Office Support
    Replies: 3
    Last Post: 24-01-2012, 04:12 PM
  3. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 04:00 PM
  4. How to Format a cell to keep leading zeros in Microsoft Excel
    By Raju Chacha in forum MS Office Support
    Replies: 3
    Last Post: 14-01-2012, 06:05 PM
  5. Text not visible in cell only in Formula Bar (excel 2003)
    By NavinS in forum MS Office Support
    Replies: 1
    Last Post: 14-02-2008, 02:32 AM

Posting Permissions

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