Date Format

  • Thread starter Thread starter Rajkumar
  • Start date Start date
R

Rajkumar

Hi,

Frequently i am downloading some datas from our ERP,in which the date'
are downloaded as in this style.

25.11.2003

i am not sure this in what format.But when i use the formulae

=days360(a1,b1,true) to find the difference between 2 dates,excel i
giving error msg as #VALUE!

pls help me to sort out this issue.

Rajkuma
 
Hi there,
check that the cell is not in text format,
try 28/11/03 to test if there is any change.
buddi
 
the cell is showing in General format.

And i need to convert 2 to 3 columnns of dates to date format.

the problem is, i need to convert these data to date format.And the
apply the function.

i tried Format cells->date, but no use.

Pls help.
Rajkuma
 
Try this.........
Highlight all the cells that have the dates in the format 28.11.2003
that you want to use then go to the replace function under the edi
menu.
Do a replace all "." with "/" or "-". You should find that your date
will be recognised by the formula.
It just does not like "." , does not recognise that as a date.
But pls do a backup or sample one cell first.
regards
buddi
 
Hi,

Frequently i am downloading some datas from our ERP,in which the date's
are downloaded as in this style.

25.11.2003

i am not sure this in what format.But when i use the formulae

=days360(a1,b1,true) to find the difference between 2 dates,excel is
giving error msg as #VALUE!

pls help me to sort out this issue.

Rajkumar
Click to expand...

I don't know what your regional settings are, but the following should work
regardless:

1. Select the column in which the dates are listed.
2. Data/Text to Columns
3. Next
4. Next
5. Column Data Format: Date: DMY
6. Finish


--ron
 
Back
Top