Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
from date format convert to text format is wrong
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
from date format convert to text format is wrong
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. -- HTH... Jim Thomlinson "nooris" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
from date format convert to text format is wrong
What happens if you type: =TEXT(A1,"yy.mm.dd")
Micky "nooris" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Text to Date format | Excel Discussion (Misc queries) | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
How to convert text into date format? | Excel Discussion (Misc queries) | |||
How to convert text into date format? | Excel Worksheet Functions |