Dates - Custom - Pos Pay Format

[Melissa]

How do I customize a Date

7/18/08

Should look like 07182008 and needs to be recognized as numbers.

Also, on my last questions about extracting the numbers only and filling
with zeros (10 places)

The formula that I was given recognized the data as text and I need it
recognized as numerical also. Can you Help?

 

[Rick Rothstein \(MVP - VB\)]

I think just custom formatting the cell entry will do what you want.
Assuming that 7/17/08 is a real date (and not simply text), right-click the
cell and select Format Cells from the popup menu that appears, select Custom
in the Category listing and put mmddyyyy into the Type field.

Rick

 

[John C]

To recognize your original post as numbers, I had suggested as such:
If you want them to still be numbers, assuming your values are in A2 and
down, type in B2, =A2*100, then go to Format|Cells, Number tab, Custom, and
type in 10 zeroes.

As far as your dates go, you can format the cells Format|Cells number tab,
custom, type in MMDDYYYY. But if you are wanting the value of, for example
07122008 = 7122008, then you will need to do something different:
=VALUE(TEXT(A1,"mmddyyyy"))

 

[Rick Rothstein \(MVP - VB\)]

Also, on my last questions about extracting the numbers only and filling

with zeros (10 places)

The formula that I was given recognized the data as text and I need it
recognized as numerical also. Can you Help?

Did you read the response from T.Valko? He provided a numeric reply. If you
used Teethless mama's code, just put a double unary (two minus signs --) in
front of the TEXT function name.

Rick