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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top