ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Regarding Microsoft Excel (https://www.excelbanter.com/excel-discussion-misc-queries/120835-re-regarding-microsoft-excel.html)

Dave F

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.



All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com