Hallo /All
i just want to represent the date as date when i chose date and convert it to number when i chose the text format but my date represent date even in general format and text as shown in thees images the second example is what i want but i don't know how 2.jpg1.jpg
Finest regards
Hazem Amin
Dates in Excel are stored as serial numbers, so it's not as simple as changing file formats. If a date is stored in date format, to get it to text, you need to use the TEXT function. If the date is stored in text format and you need the date format, there are a series of functions that will accomplish this for you. For a detailed explanation, check out the Definitive Guide to Using Dates and Times in Excel.
Get Excel tips and tutorials at ExcelTactics.com
Will check this link
Thanks in Advance
As described above, a date just a number representing how many days have passed since 1/1/1900. So today (10/5/13) is 41552. Excel deals with time as a fraction/decimal of 1 (1 day). You need to 1st test your data to see if it is numeric or text - use -isnumber(cell-ref) a FALSE answer indicates you are dealing with a text "date"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks