Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto insert values?
I am importing a .csv file and wish to have cells populate a default length
in width. If the cell doesnt take up the whole width, I would like to have zeroes (or some other value) inserted at the beginning. Example: the cell needs to be 8 characters, the number importing is only 4 and I wish to add 4 zeroes in front such as 00001234 automatically. How would I accomplish this? |
#2
|
|||
|
|||
Can you just format that column to show the leading 0's?
Select the column format|Cells|Number tab custom 00000000 If that's not enough, maybe you can use a helper column to show the leading 0's. =text(a1,"00000000") and drag down. Then copy|paste special|values and delete the original column. If I wanted this automatic, I'd record a macro when I did it the first time. Then I could run that macro to open the .csv file and do the manipulation. Rick wrote: I am importing a .csv file and wish to have cells populate a default length in width. If the cell doesnt take up the whole width, I would like to have zeroes (or some other value) inserted at the beginning. Example: the cell needs to be 8 characters, the number importing is only 4 and I wish to add 4 zeroes in front such as 00001234 automatically. How would I accomplish this? -- Dave Peterson |
#3
|
|||
|
|||
Dave,
You have answered a couple of my requests! Thank you for participating. Your information is very helpful! Rick "Dave Peterson" wrote: Can you just format that column to show the leading 0's? Select the column format|Cells|Number tab custom 00000000 If that's not enough, maybe you can use a helper column to show the leading 0's. =text(a1,"00000000") and drag down. Then copy|paste special|values and delete the original column. If I wanted this automatic, I'd record a macro when I did it the first time. Then I could run that macro to open the .csv file and do the manipulation. Rick wrote: I am importing a .csv file and wish to have cells populate a default length in width. If the cell doesnt take up the whole width, I would like to have zeroes (or some other value) inserted at the beginning. Example: the cell needs to be 8 characters, the number importing is only 4 and I wish to add 4 zeroes in front such as 00001234 automatically. How would I accomplish this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert picture | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Challenging Charting | Charts and Charting in Excel | |||
Auto Insert of Rows | Excel Worksheet Functions |