Thread: how to force excel not to change date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
  
Posts: 94
Default how to force excel not to change date?
first try to change the format of the cell to TEXT and then enter the value.

-kc
*Click YES if this helps

"tgi" wrote:

I want the cell to have 3-4 but it keeps changing it to 4-Mar.
Reply With QuoteReply With Quote