View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Regarding Microsoft Excel

Excel thinks you're trying to enter a date. Put an apostrophe to the left of
the numbers, like this: '0 4-9 or '5-9 to force XL to treat the numbers as
text and not as a date.

Dave
--
Brevity is the soul of wit.


"Maninath K" 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.