| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to fix the number filed so all numbers are 8 in length
not all the numbers are the same.
it must be 8 numerical fields but some numbers are well let me show you an example. 01234567 12345678 123 47864 3456763 They need to fixed up to look like: 01234567 12345678 00000123 00047864 03456763 How do I get excell 2003 to do this for me? Or does it need to be a script of some sort? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to fix the number filed so all numbers are 8 in length
Hi TechGuyatWork
Set the custom number format to 00000000 --- Regards, Norman "TechGuyatwork" wrote in message ... not all the numbers are the same. it must be 8 numerical fields but some numbers are well let me show you an example. 01234567 12345678 123 47864 3456763 They need to fixed up to look like: 01234567 12345678 00000123 00047864 03456763 How do I get excell 2003 to do this for me? Or does it need to be a script of some sort? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to fix the number filed so all numbers are 8 in length
unless Microsoft made some radical changes between Office 2000 and Office
2003 you could select the range you want formatted and Click on Format/Cells, select custom format and key in 00000000 in the text box. "TechGuyatwork" wrote: not all the numbers are the same. it must be 8 numerical fields but some numbers are well let me show you an example. 01234567 12345678 123 47864 3456763 They need to fixed up to look like: 01234567 12345678 00000123 00047864 03456763 How do I get excell 2003 to do this for me? Or does it need to be a script of some sort? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I retrieve a file that had another filed 'saved' over it? | Excel Discussion (Misc queries) | |||
| Pivot table filed defaults | Excel Worksheet Functions | |||
| creating numbers to a fixed length string... | Excel Worksheet Functions | |||
| Subtotal filed in pivot table in Excel? | Excel Worksheet Functions | |||
| New laptop - where are the custom button settings filed ? | Excel Discussion (Misc queries) | |||
Linear Mode
