from date format convert to text format is wrong

N

nooris

Hello All,

I download from SAP to excel a database. But unfortunately I can't convert
date cells to text. For Example: 2010.02.01 and if I convert to text format
i'll get 40181 data all cells.
I have tried to copy my worksheet to other worksheet with copy paste special
only values, but the result is same.

Please help!

Regards,
Nooris
 
J

Jim Thomlinson

In XL dates are actually stored as numbers. The number is the number of days
that has elapsed since Jan 1, 1900. So for example if you type in the number
40181 and format the cell as date you will see that the date is Jan 2, 2010.
 
×

מיכ×ל (מיקי) ×בידן

What happens if you type: =TEXT(A1,"yy.mm.dd")
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 7 I need to convert date to text 3
Remove date format? 3
Convert Date string to date format 7
Date to text format question 4
format a date to text 7
Convert Date to Text 2
Converting a date to text..Format question 2
Date format 5

Top