| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a macro to formatt data
Thanks, the 00000##### works just like I need it to.
"Naveen" wrote: - Select the cells you want - Click on "Format" menu - Click "Cells" - Click on "Number" tab - Select "Custom" from "Category" list-box - Type "000000" in "Type:" textbox - Press "OK" Button *** Please do rate *** "ATanker62" wrote: Hello I have a long colum of data in the following format xxxxx, I require the data to have five zeros before the number. Example 12345 must be changed to display as 0000012345 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a macro for data input. | Excel Discussion (Misc queries) | |||
| Macro - Add the same CC results before creating a line of data | Excel Discussion (Misc queries) | |||
| Creating a macro to line up data in 2 worksheets. | Excel Worksheet Functions | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
| Creating macro to lookup data | Excel Discussion (Misc queries) | |||
Hybrid Mode
