Hello,
I would like some advice on formatting cells to have leading zeroes. I do know about using ="0####", but my problem is somewhat more complex.
The data in the cell can vary from 10 digits to 11, to 12. What I need is that whenever the LEN=10, append 00 to the string (ie. "00##########), when LEN=11, "0###########"), otherwise no change.
I've tried using a custom cell format, but it's tedious to go through many dozens of cells applying the correct format, not to mention that the data is then only masked and can't be exported to a CSV for example.
Any help would be greatly appreciated.
Thanks
Configuration: Windows Vista Firefox 3.0.7
Hi,try this link to get help:
|
Copy command vba excel for copying formulas of one sheet into other Excel 2007 conditional format range Excel 2007 conditional formatting hide row Excel 2007 markup formula Excel 2007 user form Excel cell maximum formatconditions Excel cells have formula but say error Excel chart with formatation conditional Excel chart xvalues formatting code Excel copy conditional formatting only Excel how to format x cells based on number Excel if statement formatting change color Excel macro copy formula down column Excel macro copy formula to last data cell Excel vba commission formula Excel vba get format value Use excel plus minus formula without the cell showing 0 value Vb code to link button to the excel in macro format