Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CHANGE TEXT TO DATE FORMAT
Hi, I wonder if you would help me? I have to import a file from our accounts
package in .csv format into Excel on a daily basis. This works well apart from the date which appears as, say, 20050901. I should like it to be 01/09/2005 or similar. I have tried formatting the column into date but nothing seems to work correctly for me. Is there an easy way of converting a column to the correct format please? Thanks for your time. Denise |
#2
|
|||
|
|||
if this is the common format
use =DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(R IGHT(A1,2))) "deniseh" wrote: Hi, I wonder if you would help me? I have to import a file from our accounts package in .csv format into Excel on a daily basis. This works well apart from the date which appears as, say, 20050901. I should like it to be 01/09/2005 or similar. I have tried formatting the column into date but nothing seems to work correctly for me. Is there an easy way of converting a column to the correct format please? Thanks for your time. Denise |
#3
|
|||
|
|||
VALUE is not necessary, for me
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) also worked. Stefi €žbj€ ezt Ã*rta: if this is the common format use =DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(R IGHT(A1,2))) "deniseh" wrote: Hi, I wonder if you would help me? I have to import a file from our accounts package in .csv format into Excel on a daily basis. This works well apart from the date which appears as, say, 20050901. I should like it to be 01/09/2005 or similar. I have tried formatting the column into date but nothing seems to work correctly for me. Is there an easy way of converting a column to the correct format please? Thanks for your time. Denise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATE Format | Excel Worksheet Functions | |||
Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel | |||
How do i change numbers in text format to number format? | New Users to Excel |