Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |