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?

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


"Melissa" wrote in message
...
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?

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"))



--
John C


"Melissa" wrote:

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?

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