converting dates

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

There must be a simple way to convert 1/15/04 to 011504
and 1/6/04 to 010604.

Any help would be greatly appreciated. Thanks.
 
Hi
try formating (Menu: 'Format - Cells') the cell with the custom format:
MMDDYY
 
You must log in or register to reply here.

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

Excel How to calculate in excel number of open actions that expired (older then today) 0
How to Convert MBOX to PST Online? 3
Which is the best MBOX Converter Tool different formats conversion? 4
Help w/Duplicates & Macros 5
Formula to report dates in a new tab 2
Importing .csv with #2000-04-06 10:15:00# date format field 4
convert columns to rows 6
Coverting Dates to Text 4

Back
Top