Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
Hi,
Try this then format as required =DATE(LEFT(A5,4),MID(A5,5,2),RIGHT(A5,2)) Mike "pgarcia" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
=--TEXT(A1,"0000-00-00")
Format cell as: DATE "pgarcia" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
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 wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
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" wrote: 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 wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
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" wrote: 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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date is backwards 20090123
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... pgarcia wrote: 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" wrote: 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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forward & Backwards Quarters from an Entered Date | Excel Worksheet Functions | |||
Excel is Backwards! | Setting up and Configuration of Excel | |||
How do I calculate dates backwards from a project end date | Excel Worksheet Functions | |||
vlookup backwards | Excel Worksheet Functions | |||
Match Backwards | Excel Worksheet Functions |