Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy)
If a range of cells in Excel are formatted as dates i.e. (mm/dd/yy or
mm-dd-yyyy) etc. then the user should not have to enter the slashes or dashes when entering the date. For instance for 12-31-2006 I should only have to enter 12312006 or maybe even 123106 (if a century function can be set). Also, if a cell is formatted with two decimal places I should not have to enter the decimal point. Or better yet use add-mode data entry (like a desktop calculator). Most software is designed by engineers that arn't trained to enter data on a 10 key pad. I'm an accountant, and I generally have to enter quite a bit of transaction data in a spreadsheet, and the above suggestions would make my (and other business peoples') life easier. ---------------- 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
|
|||
|
|||
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy)
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False If Len(Target) = 8 Then ' must always enter full 4 char yyyy Target.Value = Left(Target, 2) & "/" & Mid(Target, 3, 2) & "/" & Right(Target, 4) End If If Len(Target) = 7 Then 'accomodates for months 1 - 9 Target.Value = Left(Target, 1) & "/" & Mid(Target, 2, 2) & "/" & Right(Target, 4) End If Application.EnableEvents = True End Sub "mfoley" wrote: If a range of cells in Excel are formatted as dates i.e. (mm/dd/yy or mm-dd-yyyy) etc. then the user should not have to enter the slashes or dashes when entering the date. For instance for 12-31-2006 I should only have to enter 12312006 or maybe even 123106 (if a century function can be set). Also, if a cell is formatted with two decimal places I should not have to enter the decimal point. Or better yet use add-mode data entry (like a desktop calculator). Most software is designed by engineers that arn't trained to enter data on a 10 key pad. I'm an accountant, and I generally have to enter quite a bit of transaction data in a spreadsheet, and the above suggestions would make my (and other business peoples') life easier. ---------------- 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy)
"mfoley" wrote in message
... .... Also, if a cell is formatted with two decimal places I should not have to enter the decimal point. .... Tools/ Options/ Edit/ Fixed Decimal Places -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy)
The two solutions offered are patches and not complete. First I don't like to
use macros, my people always end up screwing them up. Second the solution of setting the decimal places to 2 in the options menu changes the default to two decimals for the entire spreadsheet. Again, if a range of cells is formated "mm-dd-yyyy" then the program should recognize the format as a templet and properly punctuate the imput. It does this on some formatted ranges (i.e. percentages). Sure it will take a little extra programming but after all by formatting the cell the user is telling you what he wants. "mfoley" wrote: If a range of cells in Excel are formatted as dates i.e. (mm/dd/yy or mm-dd-yyyy) etc. then the user should not have to enter the slashes or dashes when entering the date. For instance for 12-31-2006 I should only have to enter 12312006 or maybe even 123106 (if a century function can be set). Also, if a cell is formatted with two decimal places I should not have to enter the decimal point. Or better yet use add-mode data entry (like a desktop calculator). Most software is designed by engineers that arn't trained to enter data on a 10 key pad. I'm an accountant, and I generally have to enter quite a bit of transaction data in a spreadsheet, and the above suggestions would make my (and other business peoples') life easier. ---------------- 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 | |||
Select a range of non-adjacent cells in Excel? | Excel Worksheet Functions | |||
How do I change dates from dd/mm/yy to mm/dd/yy | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions |