Thread: how do i change the default from a date to a number?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Habbakuk Habbakuk is offline
external usenet poster
  
Posts: 1
Default how do i change the default from a date to a number?
hi,
does anyone know how to change the settings so that if a number like 11-20
is entered in a cell, it will stay like that rather than turning into nov-20?
i tried changing the setting from date to general, but it then wanted to
convert it to a number like 4438.
any ideas?
many thanks.
Reply With QuoteReply With Quote