ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   numeric format (https://www.excelbanter.com/excel-programming/384205-numeric-format.html)

user

numeric format
 
have sheet with 7 columns of numbers. need to format so numbers 1 thru 9
have a 0 put in front. 01, 02, 03.....

any help?

Gary Keramidas

numeric format
 
you can try just going to format cells, click custom at the bottom of the list
click on 0, then enter 00, click ok and format the cells


--


Gary


"user" wrote in message
...
have sheet with 7 columns of numbers. need to format so numbers 1 thru 9 have
a 0 put in front. 01, 02, 03.....

any help?





All times are GMT +1. The time now is 12:17 PM.

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