|
- How do I format a social security number to have no dashes?
I have a column in Excel with social security numbers and i need to make the formatting so the number has no dashes in it So for instance 111-11-1111, should look like 11111111
- leading zeros are not showing in the formula bar but do show in ce
The SSN's that lead with zeros show up in the cell with the proper nine digit specification (no dashes or anything), because I formatted it to text However, in the formula bar (where it counts), it does not show the leading zeros How can I get the formula bar to show all nine digits including the leading zeros? Thanks!
- how do i enter a date quickly without using slashes or dashes?
Re: how do i enter a date quickly without using slashes or dashes? slwilson1430 Thank you! I have been trying to figure this out! That works perfectly!!
- How do I use hyphens instead of slashes when representing dates?
I want to use hyphens instead of slashes when representing dates in Excel
- Counting dashes [SOLVED] - Excel Help Forum
Counting dashes Hello all, Hopefully a simple one I'm looking for a formula to count specific characters in a cell e g Cell A1="A-HW, A-BM, A-CD" I would like to count how many times "-" appears in the cell I tried searching the forum for something similar but it appears empty Regards, Chris
- Replace any non-alphanumeric char with dash - Excel Help Forum
1 Any multiple dashes -- --- ----- for instance, need to be replaced with 1 dash So inbetween words there is always only be 1 dash Never more than 1 dash next to each other 2 Any leading dashes at the very start need to be removed and not replaced, so -my-bike-is-red would become my-bike-is-red so no dashes ever at the beginning 3
- No dashed lines when copying text in Excel [SOLVED]
No dashed lines when copying text in Excel For the longest time I've always gotten dashed lines when I am copying or even cutting text from Excel One day the dashed lines no longer appear but are now solid lines I would like to have my dashed lines back but have looked at every setting I can think of and nothing!
- Removing Parenthesis, spaces and dashes from Phone numbers
Re: Removing Parenthesis, spaces and dashes from Phone numbers Can't you re-format them as general? HAve you tried to set general format to all your number? I think i must work for you Last edited by contaminated; 01-14-2010 at 01:51 PM
|
|
|