Quote:
Originally Posted by lyngio
Hi all,
I am experiencing an issue with date formatting in EXCEL 2003.
I have a cell which I have custom formatted to dd-mmm which 'should' return 04-Jan when 4/1 is entered into that cell...Yes???
My problem is that I am getting 1-Apr as the result...??? 
Suggestions??????  |
Quote:
Originally Posted by Catalin.B
you shoud enter data according to your regional settings in control panel...
if you are in USA, 1/4/2012 means 4 jan 2012.
or, here in Romania, i use 4/1/2012 for 4 ian 2012.
Then, if you enter 4/1, this means you first enter month!!, that's why it shows 1 -apr. You can format the cell to show date in your custom way (the excel number for that date is the same, no matter how YOU CHOOSE TO SEE that number), but data should be entered according to reg. settings.
|
Yes I have checked that....
It is set as English (Australia) so by entering my date(s) as 4/1 it 'should' be showing in the cell as 4-Jan as my formatt for that cell is d-mmm........