Date Conversion

  • Thread starter Thread starter FinChase
  • Start date Start date
F

FinChase

Hi,
I need to convert dates that are currently in m/d/yyyy format to yyyymmdd
format. I've tried doing a string function using right, left, and mid, but
I'm getting back the serial date format. Can anyone help with this?

Thanks-
 
hi,

Have you tried

format|Cells|Custom
enter a custom format of
yyyymmdd

Mike
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
Text to Date 8
Convert Date string to date format 7
How do I change the date format? 3
Formatting the date 1
counting records by month and year / date format issues 1
Excel date format YYYYMMDD 1
Date Seperator 2

Back
Top