LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select a range of non-adjacent cells in Excel? hodgsonk Excel Worksheet Functions 12 July 1st 06 04:34 AM
How do I change dates from dd/mm/yy to mm/dd/yy Dotteee Setting up and Configuration of Excel 2 November 17th 05 02:02 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel - formula to calculate colored fill cells within a range wi. MA Excel Worksheet Functions 1 January 7th 05 04:06 PM
How do I change an Excel range of cells from relative to absolute. Jrhenk Excel Worksheet Functions 2 November 15th 04 10:55 PM


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"