cell format
How can I change single digit to two digits number
e.g. 3 to 03 I have used custom cell format by 0# but it fails if it is 0. It cannot change to 00 Thanks OS: win2k Office 2k |
cell format
Lamb Chop Wrote: How can I change single digit to two digits number e.g. 3 to 03 I have used custom cell format by 0# but it fails if it is 0. It cannot change to 00 Thanks OS: win2k Office 2kHi Lam Chop, Have you tried the custom format of 00 or 00; -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=564920 |
All times are GMT +1. The time now is 08:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com