Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
loosing test fomat after using replace command
we are importing payroll information which includes a SS number formatted
with the dashes (xxx-xx-xxxx). The infomation is used to upload to the state which requires the data to be in CSV format with no dashes in the SS number. If we format the SS column as TEXT and apply the replace all to the column reqursting that (-) be replaced with ( ), the dashes are sucessfully removed, but the fromat seems to revert to general and any SS number that has a leading 0 has the zero dropped. Any suggestion as to how to now loose the leading zero thru the process? |
#2
|
|||
|
|||
loosing test fomat after using replace command
If you format the resulting cell as: 000000000
You'll see your leading 0's. And if you save as a .csv, then open that .csv in Notepad, you'll be able to see how it worked. Or... Use a helper column of formulas: =substitute(a1,"-","") And drag down. This will return a string. Richard Miller wrote: we are importing payroll information which includes a SS number formatted with the dashes (xxx-xx-xxxx). The infomation is used to upload to the state which requires the data to be in CSV format with no dashes in the SS number. If we format the SS column as TEXT and apply the replace all to the column reqursting that (-) be replaced with ( ), the dashes are sucessfully removed, but the fromat seems to revert to general and any SS number that has a leading 0 has the zero dropped. Any suggestion as to how to now loose the leading zero thru the process? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the command to replace a cell's formula with it's value? | Excel Discussion (Misc queries) | |||
use replace command to change the contents of formulas | Excel Discussion (Misc queries) | |||
Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
replace command | Excel Discussion (Misc queries) |