Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Define the format of a cell in excel 2003

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 02-10-2009
Member
 
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.

Reply With Quote
  #2  
Old 02-10-2009
Member
 
Join Date: May 2008
Posts: 4,828
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.
Reply With Quote
  #3  
Old 02-10-2009
Member
 
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.
Reply With Quote
  #4  
Old 02-10-2009
Member
 
Join Date: May 2008
Posts: 4,338
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 05:32 PM.