Excel Date changing format

June 11, 2010 at 18:53:27
Specs: Windows XP
As i need to copy a big column of date in the format of 12/6/2010 from one file to another file, I don't want to copy this format to the new file.
I would like to see that when I copy 12/6/2010 from the old file,the new file will appear 12-6-2010.
Is there any method that can help me to do this process?

See More: Excel Date changing format

Report •

#1
June 11, 2010 at 19:12:43
from one file to another file,

What type of files are they?

MIKE

http://www.skeptic.com/


Report •

#2
June 11, 2010 at 19:24:03
Both are excel file

Report •

#3
June 11, 2010 at 19:31:07
In your new sheet Custom Format the dates:

On the Task Bar,
Format
Cells
Custom Format

mm-dd-yyyy

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 11, 2010 at 19:45:12
I would like to know is there any method(fomula) that can convert this format automatically?

Report •

#5
June 11, 2010 at 20:22:26
When you enter the date into the cell it will automatically convert to mm-dd-yyyy.

So if you enter 12/06/2010 or if you have cells that already contain the date, the custom formatting will change the display to 12-06-2010.

MIKE

http://www.skeptic.com/


Report •

#6
June 11, 2010 at 20:33:40
That's the problem, when i copy the date from another excel file with the format dd/mm/yyyy, finally the format dd/mm/yyyy will also be copied and replace the format dd-mm-yyyy in the new file.

Report •

#7
June 11, 2010 at 20:36:52
Do a Paste Special, and select Value.
That way you do not paste the original format.

Or just re-do the custom format in the new sheet.

MIKE

http://www.skeptic.com/


Report •

#8
June 11, 2010 at 20:47:40
Yes,
It can be do like this,
but if i want to get like 12-3-2010,
is there any method?
Because according your method, the result will be 12-March-2010

Report •

#9
June 11, 2010 at 20:59:34
In Custom Formatting dates,

Month

    m will give you 1-12
   mm will give you 01-12
  mmm will give you Jan-Dec
 mmmm will give you January-December
mmmmm will give you J-D

Day
   d will give you 1-31
  dd will give you 01-31
 ddd will give you Sun-Sat
dddd will give you Sunday-Saturday

Year
  yy will give you 00-99
yyyy will give you 1900-9999

How do you have your format?

mm/dd/yyyy will give you 01/01/2010

mmm/ddd/yyyy will give you Jan/Fri/2010

mmm/dd/yy will give you Jan/01/10

Look here for tips on Custom Formatting:
http://office.microsoft.com/en-us/e...

MIKE

http://www.skeptic.com/


Report •

#10
June 11, 2010 at 21:03:18
o thanks
I think i will be okay

Report •

Ask Question