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/120836-regarding-microsoft-excel.html)

Maninath K

Regarding Microsoft Excel
 
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.

Gord Dibben

Regarding Microsoft Excel
 
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.




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

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