Search : in
By :

Format Cells Excell

Last answer on May 7, 2009 7:33:11 am BST AZGeorge, on May 1, 2009 6:18:00 pm BST 
 Report this message to moderators

Hello,
I would like to format a cell in excell to accept dd/mm/yyyy or just yyyy.
Excel 2007 using windows vista premium.

If not excel, I would like to do the same with access 2007, have the option to use dd/mmm/yyyyy or just yyyy.

Configuration: Windows Vista Internet Explorer 8.0

Best answers for « Format Cells Excell » in :
DATE FORMATTING IN dd/mm/yyyy Show
Excel Formula Display in Cell (Solved) Show
Worksheet - Cells Show The Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
[Excel]Storage name and path of a spreadsheet Show[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Excel – Formula for cell calculation ShowExcel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

 mubashir aziz, on May 7, 2009 7:33:11 am BST

Do you want restrict user to enter only in this format ? ?????

or you just wanna format the cell in date format ???????

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz
Ask your question Reply
They need your help