data structure in Excel format
Vk Duggal (320 Points)
10 May 2007
Can any body guide from where date format in excel format can be obtained.
4 Replies
Viswanath
(13 Points)
Replied 10 May 2007
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
Mohit Jain
(CHARTERED ACCOUNTANT)
(86 Points)
Replied 10 May 2007
RIGHT CLICK->FORMAT CELLS->NUMBER->DATE(fifth item)
Shipra
(25 Points)
Replied 10 May 2007
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
- Form 3CEAA and Form 3CEAB
- DIR 3 Web KYC
- Can i declare LTCG income as business income if I
- Stock entry in new software
- I have an EMI collection shop, what is its SAC cod
- Making payment once in quarter possible under QRMP
- Master File Documentation related
- Applicability of 44AD needs clarification
- ITC reversal in GST 3B
- Claim if ITC on stocks 19-2020 conversion from com
Related Threads
CAclubindia
