Thread: how do i stop excel from converting numbers entered into a date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default how do i stop excel from converting numbers entered into a date
Select the range. From menu select FormatCells and forma that to General.

--
Jacob (MVP - Excel)


"newuser" wrote:

everytime i enter a number into a cell excel converts it into a date i need
that data to stay as entered
Reply With QuoteReply With Quote