software

I'm having difficulty with a spreadsheet and socials - I need to format them
so the leading zeros remain and the hyphens go away. I was given a concate
formula but in order to make that work I have to put it into the spreadsheet
and I can't use the column where it goes. The parameters are assigned for
uploading a flat file into our system. Can someone help me with low level
directions. I'm literate but not that literate.
Cheri

If the SSNs are text fields:
'001-23-4567
then just do Edit gt; Find and enter -
In the Replace field enter nothing

You should see:
'001234567

--
Gary's Studentquot;Cheriquot; wrote:

gt; I'm having difficulty with a spreadsheet and socials - I need to format them
gt; so the leading zeros remain and the hyphens go away. I was given a concate
gt; formula but in order to make that work I have to put it into the spreadsheet
gt; and I can't use the column where it goes. The parameters are assigned for
gt; uploading a flat file into our system. Can someone help me with low level
gt; directions. I'm literate but not that literate.
gt; Cheri

I've tried that but when I copy and paste from the original spreadsheet into
my template, it reverts back to SSN format. The concat formula works great
but I can't have it in my spreadsheet. I've tried the find/replace but it
drops the zeros.

quot;Gary''s Studentquot; wrote:

gt; If the SSNs are text fields:
gt; '001-23-4567
gt; then just do Edit gt; Find and enter -
gt; In the Replace field enter nothing
gt;
gt; You should see:
gt; '001234567
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Cheriquot; wrote:
gt;
gt; gt; I'm having difficulty with a spreadsheet and socials - I need to format them
gt; gt; so the leading zeros remain and the hyphens go away. I was given a concate
gt; gt; formula but in order to make that work I have to put it into the spreadsheet
gt; gt; and I can't use the column where it goes. The parameters are assigned for
gt; gt; uploading a flat file into our system. Can someone help me with low level
gt; gt; directions. I'm literate but not that literate.
gt; gt; Cheri

After you replace the dashes with nothing, format the cells as Custom:
000000000

Select the cells
Format | Cells | Number
Click Custom and type 000000000 in the space provided.

--
tjquot;Cheriquot; wrote:

gt; I've tried that but when I copy and paste from the original spreadsheet into
gt; my template, it reverts back to SSN format. The concat formula works great
gt; but I can't have it in my spreadsheet. I've tried the find/replace but it
gt; drops the zeros.
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; If the SSNs are text fields:
gt; gt; '001-23-4567
gt; gt; then just do Edit gt; Find and enter -
gt; gt; In the Replace field enter nothing
gt; gt;
gt; gt; You should see:
gt; gt; '001234567
gt; gt;
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;Cheriquot; wrote:
gt; gt;
gt; gt; gt; I'm having difficulty with a spreadsheet and socials - I need to format them
gt; gt; gt; so the leading zeros remain and the hyphens go away. I was given a concate
gt; gt; gt; formula but in order to make that work I have to put it into the spreadsheet
gt; gt; gt; and I can't use the column where it goes. The parameters are assigned for
gt; gt; gt; uploading a flat file into our system. Can someone help me with low level
gt; gt; gt; directions. I'm literate but not that literate.
gt; gt; gt; Cheri

Thank you - that works and your answer was easy to understand. Muchas Grass!

quot;tjtjjtjtquot; wrote:

gt; After you replace the dashes with nothing, format the cells as Custom:
gt; 000000000
gt;
gt; Select the cells
gt; Format | Cells | Number
gt; Click Custom and type 000000000 in the space provided.
gt;
gt; --
gt; tj
gt;
gt;
gt; quot;Cheriquot; wrote:
gt;
gt; gt; I've tried that but when I copy and paste from the original spreadsheet into
gt; gt; my template, it reverts back to SSN format. The concat formula works great
gt; gt; but I can't have it in my spreadsheet. I've tried the find/replace but it
gt; gt; drops the zeros.
gt; gt;
gt; gt; quot;Gary''s Studentquot; wrote:
gt; gt;
gt; gt; gt; If the SSNs are text fields:
gt; gt; gt; '001-23-4567
gt; gt; gt; then just do Edit gt; Find and enter -
gt; gt; gt; In the Replace field enter nothing
gt; gt; gt;
gt; gt; gt; You should see:
gt; gt; gt; '001234567
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Gary's Student
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Cheriquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I'm having difficulty with a spreadsheet and socials - I need to format them
gt; gt; gt; gt; so the leading zeros remain and the hyphens go away. I was given a concate
gt; gt; gt; gt; formula but in order to make that work I have to put it into the spreadsheet
gt; gt; gt; gt; and I can't use the column where it goes. The parameters are assigned for
gt; gt; gt; gt; uploading a flat file into our system. Can someone help me with low level
gt; gt; gt; gt; directions. I'm literate but not that literate.
gt; gt; gt; gt; Cheri

THANKS! I had read in the Excel Bible something like this but was unable to
make it work until your post!

quot;Gary''s Studentquot; wrote:

gt; If the SSNs are text fields:
gt; '001-23-4567
gt; then just do Edit gt; Find and enter -
gt; In the Replace field enter nothing
gt;
gt; You should see:
gt; '001234567
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Cheriquot; wrote:
gt;
gt; gt; I'm having difficulty with a spreadsheet and socials - I need to format them
gt; gt; so the leading zeros remain and the hyphens go away. I was given a concate
gt; gt; formula but in order to make that work I have to put it into the spreadsheet
gt; gt; and I can't use the column where it goes. The parameters are assigned for
gt; gt; uploading a flat file into our system. Can someone help me with low level
gt; gt; directions. I'm literate but not that literate.
gt; gt; Cheri