View Single Post
  #4   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?

Then again maybe you're not entering dates but trying to enter data like

12-06 which Excel interprets as a date.

Preface with an apostrophe so Excel knows it is to be text.

OR pre-format the cell(s) as Text.


Gord

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

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