Format the cells as Text before entering the data.

OR precede each with an apostrophe.

You won't see the apostrophe but it ensures the data is entered as text.


Gord Dibben MS Excel MVP

On Wed, 29 Nov 2006 05:23:01 -0800, Maninath K <Maninath
wrote:

Hi,

This is Mani,,
When i type in Excel sheet as 0-4, 5-9 then immediately i get -- 9-May.

How to come out this kind of issues...

any suggestions.