| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a macro to put "-" between existing numbers?
I have a spreadsheet containing Social Security numbers. All need to be in
the format ###-##-####. How do I create a macro to do this on a cell that has the format #########? So far what I get is that the macro changes the SS# to be the same as the one I changed when creating the macrol. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I create a macro to put "-" between existing numbers?
Why not just do it with a custom format. Select the area you want to modify
and right click. Choose Format Cells. Choose Custom. Type in 000-00-0000... -- HTH... Jim Thomlinson "Steverino" wrote: I have a spreadsheet containing Social Security numbers. All need to be in the format ###-##-####. How do I create a macro to do this on a cell that has the format #########? So far what I get is that the macro changes the SS# to be the same as the one I changed when creating the macrol. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I create a macro to put "-" between existing numbers?
Thanks for the help. However, I am creating a spreadsheet to use as an
import to setup a database. I therefore actually need to insert the dashes. "Jim Thomlinson" wrote: Why not just do it with a custom format. Select the area you want to modify and right click. Choose Format Cells. Choose Custom. Type in 000-00-0000... -- HTH... Jim Thomlinson "Steverino" wrote: I have a spreadsheet containing Social Security numbers. All need to be in the format ###-##-####. How do I create a macro to do this on a cell that has the format #########? So far what I get is that the macro changes the SS# to be the same as the one I changed when creating the macrol. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| Insert "Proper Function" into existing macro | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| SaveAs macro: How do I specify "Replace existing file?" | Excel Programming | |||
| How do you replace an existing file, saying "yes" in a macro? | Excel Programming | |||
Linear Mode
