Thread: hyphen to forward slashes?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default hyphen to forward slashes?
"It" I assume is Excel.

Are you entering Dates like 2-12-2006 which Excel changes to 2/12/2006?

Windows Regional Settings and Languages governs how dates are entered.

Change your "short date" to use hyphens.


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 16:16:01 -0700, bailbust63
wrote:

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

Reply With QuoteReply With Quote