Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

How can I stop Excel from turning the number ranges I enter (eg 1.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jenny - 11 Oct 2006 21:36 GMT
I've been trying to put together a spreadsheet of addresses, so I need to be
able to include addresses that include number ranges - eg. 11-12 High Street
or 14-16 Main Road. The problem is that in the column in which I enter the
number part of the address, these kind of addresses keep getting turned into
dates - so 11-14 becomes Nov 14. How can I get these to display as I've
originally typed them?? Help would be much appreciated!
Biff - 11 Oct 2006 21:53 GMT
Hi!

You can either preformat the cells as TEXT or precede the entry with an
apostrophe, like this: '11-14. The apostrophe will not be displayed in the
cell.

Biff

> I've been trying to put together a spreadsheet of addresses, so I need to
> be
[quoted text clipped - 5 lines]
> dates - so 11-14 becomes Nov 14. How can I get these to display as I've
> originally typed them?? Help would be much appreciated!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.