View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default hyphen to forward slashes?

Are you entering stuff that looks like a date?

And you want to keep excel from helping you out by changing it to a date?

If yes,

you can preformat the cell as text (format|cells|number tab)
or
start your entry with an apostrophe: '1-3



bailbust63 wrote:

how do i stop it from changing my hyphen to forward slashes?


--

Dave Peterson