ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Number Format Question (https://www.excelbanter.com/excel-discussion-misc-queries/230763-excel-number-format-question.html)

snolte

Excel Number Format Question
 
How do you keep the zero in front of a number when the cell is formatted as a
number(example 01423)? This needs to stay formated as a number for importing
reasons.

Dave Peterson

Excel Number Format Question
 
I'm not sure what that last sentence means, but you can use:

Select the range
(in xl2003 menus)
format|cells|number tab
custom category
00000



snolte wrote:

How do you keep the zero in front of a number when the cell is formatted as a
number(example 01423)? This needs to stay formated as a number for importing
reasons.


--

Dave Peterson


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

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