I need a left side padding for numeric values to keep them in 4 digits
ie 1 becomes 0001, 25 becomes 0025 and 345 becomes 0345. Following is the custom number format I tried and it fails. Can somebody help.
[<10]"000"#;[<100]"00"#;[<1000]"0"#
rgds
johnjohns
Last edited by johnjohns; 02-03-2010 at 09:15 AM.
Try just:
0000
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Vow! Works absolutely fine!! Thanks a million, NBVC! I spent 1 hr on R&D to get a solution and you showed me how simple it is!!
rgds
johnjohns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks