ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Formatting Query (https://www.excelbanter.com/excel-discussion-misc-queries/115351-cell-formatting-query.html)

shakey1181

Cell Formatting Query
 
....and one more thing if possible... sorry...

How do I set the format of a cell so you can always enter a two digit number
[i.e 01-09] without it switching automatically to a one digit number? I need
to do this without using text or general formats...

Thanks again all!

David Biddulph

Cell Formatting Query
 
Format/ Cells/ Custom:
00
--
David Biddulph

"shakey1181" wrote in message
...
...and one more thing if possible... sorry...

How do I set the format of a cell so you can always enter a two digit
number
[i.e 01-09] without it switching automatically to a one digit number? I
need
to do this without using text or general formats...

Thanks again all!





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

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