Format cells problem

A

associates

Hi,

I was wondering if anyone might be able to help me. I don't know how t
get around this problem. I was trying to enter a value of 02-30 into
cell in a worksheet and it turned it into a date such as Feb-30. (ver
frustrated). I have tried the format cells but it changed it into som
other large number if i selected general or number from the optio
under format cells.

Is there a way to tell excel that this is not a cell?

Thank you very muc
 
D

Dave Peterson

You can preformat the cell as Text
or
you can precede your entry with an apostrophe: '02-30
 
Top