Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Adam Carlson
 
Posts: n/a
Default If I wanted 5-7 to mean May 7th, I would type "May 7th"

I dont understand why a non-pro user at excel has to go searching for a way
to turn this function off. Does Microsoft not care about those of us who
dont use Excel on a everyday-forwork-basis?

----------------
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...excel.newusers
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default If I wanted 5-7 to mean May 7th, I would type "May 7th"

I agree that it is stupid. Don't know if you know this or not but you can
precede the entry with an apostrophe or format the cell(s) as text prior to
entering the data

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Adam Carlson" <Adam wrote in message
...
I dont understand why a non-pro user at excel has to go searching for a way
to turn this function off. Does Microsoft not care about those of us who
dont use Excel on a everyday-forwork-basis?

----------------
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...excel.newusers


  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bondi
 
Posts: n/a
Default If I wanted 5-7 to mean May 7th, I would type "May 7th"

Hi,

A workaround would be to format the cells as Text (Right click cell -
Format Cells - Number and chose Text) If you do this befor you enter
5-7 then it should stay as 5-7

Regards,
Bondi

Reply
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
Data type auto convert sickmind Excel Discussion (Misc queries) 1 May 6th 06 12:58 PM
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 04:55 PM
Can I set the numerical type of Cell to Hex format hon123456 Excel Discussion (Misc queries) 2 January 13th 05 01:01 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 5th 05 11:25 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 08:44 PM.

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"