Ask Experts Questions for FREE Help !
Ask
    LilyGhost's Avatar
    LilyGhost Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 2, 2009, 04:59 AM
    Date Conversion
    Hi everybody
    I just wanted to know how to convert Hijri date in a column in Excel2007 into Gregorian?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Aug 2, 2009, 09:26 AM

    This REALLY depends on what is REALLY in that cell. Dealing with dates is a bit of magic trick because very seldom do we see what is really in that cell, rather we see a "specific visual formatting" of the hidden number in the cell Excel uses to identify dates to itself.

    I would think if the value is truly a standard Excel value formatted to display as Hijri, then you could simply apply a different (gregorian) date format and it would display properly.

    So, read here and see if this helps you:
    How to enter and use Hijri date in Microsoft Excel 2003

    If not, post up a sample workbook showing your actual data in these date cells and we'll take a look.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Call I have my court date canceled and do it on a later date [ 1 Answers ]

I have a court date for Oct 20 for a scheduling conference for a credit card debt. I was served a summons to file an answer and I did in a timely manner then I received a Notice of Hearing that says the case is scheduled for Scheduling Conference. Can I do anything at this point. I had previously...

Invoice Date or Actual Date [ 2 Answers ]

Is it proper to post payment requests by the invoice date or by the actual date? I ask because if you post by invoice date, you never have a hard close. What if you get an invoice in September for a July invoice date? As long as it is in the same fiscal year, does it matter?

Outlook Express to Outlook conversion gave messages wrong "Date Received." [ 1 Answers ]

Hi, All! I used Outlook's Import capbility to import everything from Outlook Express: mail settings, folders, their messages, etc. The import process reported successful import of my huge sets of folders, subfolders and their 11,000+ messages... however: The Good: Some messages were...

To-date total based on current date [ 1 Answers ]

:confused: I am trying to create a forumula that will give a cumulative or "to-date" total that will exclude future months from the total. i.e. ithe point in time is August and I need to show a to-date number Through August only even though September and October are included in The...

F-1 to H-1, what's the start date of H-1? Should be approval date or visa issue day? [ 3 Answers ]

As I mention before, I changed from F-1 to H-1 last year. I got my H-1 status in Feb 2004, but I went to my home country to get the H-1 visa stamp in August 2004. So I would like to know for counting my H-1 status, is it the date that USCIS (the Immigration) approved (which is Feb 1st), or the...

View more questions Search