Thread: Cell Formats
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Cell Formats

Two choices:
Either precede your entry with an apostrophe '. The apostrophe will
not show in the cell, only the formula bar.
Or give the cell the number format of Text

HTH
Kostis Vezerides

On Jul 2, 8:21 pm, 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