| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formmatting a bit like accountancy please
I love Excel. I love the clarity and depth it can give to data. I love the
formatting available - but there is one thing I'd really like to be able to see - and that's column formatting for long dates so that the days all line up, the months all line up and the years all line up - the only way I can do it is to place the three parts of the date in separate columns and hide the column with the date - and inserting a couple of blank columns. It's fiddly when I reckon it would be neat to enable this to be done automatically. Thanks for a fine product ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formmatting a bit like accountancy please
Presumably by 'long dates' you are talking about the length of the written
words of the month i.e. January and May and the fact they they are different. If so why do you need to have such formatting? Why not 01/12/10 and 03/13/04? That way they line up perfectly. Just like accountancy as you ask. -- Russell Dawson Excel student "Paul Nolan" wrote: I love Excel. I love the clarity and depth it can give to data. I love the formatting available - but there is one thing I'd really like to be able to see - and that's column formatting for long dates so that the days all line up, the months all line up and the years all line up - the only way I can do it is to place the three parts of the date in separate columns and hide the column with the date - and inserting a couple of blank columns. It's fiddly when I reckon it would be neat to enable this to be done automatically. Thanks for a fine product ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
