EXCEL

K

KEVIN

DOES ANYONE KNOW HOW TO GET A DATE FORMATTED TO MM/DD/YYYY
WHEN IT COMES TO YOU AS AN UNFORMATTED FIELD AS FOLLOWS

20031202 (YYYYMMDD)

THANKS KEVIN
 
J

Jason Morin

Try:

=TEXT(A1,"00\-00\-00")*1

and press Ctrl+1, and format as mm/dd/yyyy.

HTH
Jason
Atlanta, GA
 
H

Harlan Grove

KEEPS TELLING ME THAT NEGATIVE DATES OR TIMES ARE
DISPLAYED AS ##########
Click to expand...

Stop posting in all caps. It's considered shouting, and if you do it often
enough, you may be ignored or receive nothing more than helpful advice on how to
use the newsgroup responsibly but little or nothing with regard to your Excel
problem.

Given the sample date from your original posting, 20031202, and if it were in
cell A1, Jason's formula

=TEXT(A1,"00\-00\-00")*1

(which could be shortened to =TEXT(A1,"0\-00\-00")*1, but I digress) converts
the result into a date serial number. If you're trying to use double unary
minuses rather than multiplication by 1, then be sure you have *TWO* (note the
appropriate use of SHOUTING for emphasis) minus signs.

=--TEXT(A1,"00\-00\-00")
 

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

VBA - exporting serial letters to single documents 0
Converting Birth Date format 1
How to add day to PWA 2016 date format? 0
Create a dynamic master file 1
Date Format 10
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
Date Formats 4
Publisher is filling blank lines with data 2

Top