Thread: Cell Formats
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Cell Formats

formatt the cells (or columns) you will be entering the data into as 'text'
before you start entering data.

"ej" wrote:

I have been trying to enter 01-63 as an exaple and it always changes it into
a date like jan-63. I have tried everything i can think of to fix it. Any
suggestions please let me know