Date is backwards 20090123

[pgarcia]

How can I fix this? I had used a formula years back but can't remmeber how it
goes. Thanks

=DATE(right(A1,2),mid(a1,5,2),left(A1,4))

but it does not work.

Thanks

 

[Mike H]

Hi,

Try this then format as required

=DATE(LEFT(A5,4),MID(A5,5,2),RIGHT(A5,2))

Mike

 

[Teethless mama]

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

Format cell as: DATE

 

[Dave Peterson]

If the data is in a single column, you could select that column and use
data|text to columns (in xl2003 menus)

Fixed witdth, but don't draw any lines
and then choose date (ymd) as the field as the column format

And then format the range the way you like.

 

[pgarcia]

Thanks. Could I bug you for something. No one seem to anwering me on Subject:
Gray out Sub Totals not being used. Could you take a look at it for me? Thanks

 

[Dave Peterson]

I've seen the question that you posted (a few times).

My guess is that either people don't understand what you mean or it's not
possible. I fall in the first category. I'm not sure what you mean.

 

[pgarcia]

I wish we could use screen shots here.

What I have been ask to do is this: You have the layout of a typical
subtotal. The "two" view is selected or collapse to only show the "totals".
What I did was populate the blank cell to right of the subtotal to show data
from the list. When my user click on the "+" button it will expand the
subtotal showing the rest of the data. So, what I been ask to do or find out
how to do this: when the user click on the "+", it will gray out or color the
cell all white above and below it to only show the data that is expanded.
I hope the make since, if not I can email a video showing what I need.

Thanks for the help. And yes, I did post it twice. I would be nice if
someone would just answer back with "can't be done" that way, we know someone
read it.

 

[Dave Peterson]

First, if you don't get an answer, then the usual problem is that people don't
understand the question--or the solution would require way too much time for the
typical responder (and maybe hiring a consultant would be a good idea).

Second, instead of starting a new thread, you could have posted a followup with
more information -- but in the same thread.

Third, I don't think that there's anything built into excel that would allow you
do to this.

The closest thing I could see (but I don't completely understand what you've
done) is that you could use the worksheet_Calculate event and look at the rows
that are visible and apply some formatting that way.

But since you could expand the collapsed rows to show all the details, I'm not
sure how you'd approach exactly what you want.

As an alternative, you may want to look at Data|Pivottables.

You can get that nice summary and you can drill down to just the rows that were
used to create that total/sum/average...

I wish we could use screen shots here.

What I have been ask to do is this: You have the layout of a typical
subtotal. The "two" view is selected or collapse to only show the "totals".
What I did was populate the blank cell to right of the subtotal to show data
from the list. When my user click on the "+" button it will expand the
subtotal showing the rest of the data. So, what I been ask to do or find out
how to do this: when the user click on the "+", it will gray out or color the
cell all white above and below it to only show the data that is expanded.
I hope the make since, if not I can email a video showing what I need.

Thanks for the help. And yes, I did post it twice. I would be nice if
someone would just answer back with "can't be done" that way, we know someone
read it.