ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   In Format - General-How do I change it to an even number like 24 (https://www.excelbanter.com/excel-worksheet-functions/232636-format-general-how-do-i-change-even-number-like-24-a.html)

mjh

In Format - General-How do I change it to an even number like 24
 
In microsoft Excell.... The Number Format. The General tab shows 24 - a 2
digit number... sometimes it shows something else...how do I get it to
always show a one or two digit number... and that appear in the cell.



Gord Dibben

In Format - General-How do I change it to an even number like 24
 
Don't type more than two digits in the cell and make sure you are always
formatted to General.

BTW.........what is "something else"?


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 10:31:01 -0700, MJH
wrote:

In microsoft Excell.... The Number Format. The General tab shows 24 - a 2
digit number... sometimes it shows something else...how do I get it to
always show a one or two digit number... and that appear in the cell.




All times are GMT +1. The time now is 01:19 AM.

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