Menu
data structure in Excel format
Can any body guide from where date format in excel format can be obtained.
Replies (4)
Select Format - Cells - Number - Select Category = Data.
Check it out in FORMAT - CELLS - in the category u will find date. Else u can create your own date format in custom - just give the fomat in type - use dd for date mm for month and yyyy for year. if you give three mmm it will show month in three letters - so on so forth
RIGHT CLICK->FORMAT CELLS->NUMBER->DATE(fifth item)
hi ya sure
alt+o+e is a short cut for format cells or else try this right click on the cell u want to format then there is a option format cells click there is date optin in it or can go to custom (in the end) and write ur own format which u want..apply and then k
alt+o+e is a short cut for format cells or else try this right click on the cell u want to format then there is a option format cells click there is date optin in it or can go to custom (in the end) and write ur own format which u want..apply and then k
Recent Topics :
- Itr form for Salary income, Interest, Dividend And
- Will my TDS be deducted as NRI?
- PENSION ARREAR RECEIVED - EPS 95 SCHEME
- Processing of Form 144 (prev 27Q)
- Capital Gain on sale of Vacant Land- Whether Demol
- Hello dear I want help .
- Category B/D pop up after the file is e verified
- Section 56(2)(x)(xi) applicability to compensation
- How to claim exempt income u/s 10(26) in ITR-1 of
- 63053900 tax rate
Related Topics :
CAclubindia
