custom format changes to special

I need to regularly reformat numbers in cells into a custom number 
(000000000).  I create a formatted cell and place a number 1 in it 
(000000001).  I thne copy it and use paste special multiply. This has work 
great reformatting cells until this week.  I tried it and now the cell 
formats itself into Special Social Security (Portuguese) format.  It changes 
all of the cells even the orginal.  Any ideas?  I can not change it back.  I 
need the formatting to help with vlookups

Thanks
Jan 
0
Utf
5/10/2010 10:56:01 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

0 Replies
1043 Views

Similar Articles

[PageSpeed] 52

Reply:

Similar Artilces:

Changing RecordSource Causes A Reload of Sub Form Destroying References
Apologies for posting in two newsgroups but after I originally posted it in forms I realized this should have been posted here (formscoding) instead. Access 2007 This only happens on some machines. It has occurred on a PC running Windows XP SP3 and a MAC running Windows. I have been unable to reproduce it on other PCs running Windows XP SP3, Vista or Windows 7. On the machines that have the problem it always occurs. I have a form with a sub form control. The control's SourceObject is changed depending on the function required. On the forms that is used in the control is a...

view email in html format
i just switched from express to outlook 97 v8.02 and now my email opens in text format. it did open in html if required when i was using express v6.0. how can get my email to open in html format instead of text? ...

How to do evevet that triggers when a textbox value is changes
Hi I would like to know how to make event that trigger when a textbox (Unbound) changes. For example I have a textbox unbound with the value for example 999 and when the value have changed then event needs to be triggered. Thanks While the BeforeUpdate event doesn't work for unbound controls, the AfterUpdate one does. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Chipcom" <bz1977@gmail.com> wrote in message news:1193765222.443627.8450@19g2000hsx.googlegroups.com... > Hi > > I would like to know how to make event that t...

Conditionally format points based on a third column
I would like the color of my data points to vary based not on their x or y value, but rather on a third column running alongside them. How can I do it? Assuming your third column is column "C" and that you would want to change the colors of the XY points based on the names Jim, Frank, or Kim, a VBA option could look like this (does not include any error handling): Sub ChangeXYColors() Application.ScreenUpdating = False Dim Rng As Range Cnt = 1 For Each Rng In Range("C2:C10") ActiveSheet.ChartObjects("Chart1").Activate ActiveChart.Seri...

New Section break changes prior formatting
When I enter a new section after a break if I center a line all text in that section centers. If I format for "justify" the pictures in the prior sections also go to the left of the page. Which version of Word? frustrated wrote: >When I enter a new section after a break if I center a line all text in that >section centers. If I format for "justify" the pictures in the prior >sections also go to the left of the page. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-word-general/201001/1 ...

How to track "Keep the Change" from B of A?
Hello, I have a Bank of America checking and savings with the Keep the Change feature, where my debit card charges are rounded up to the next dollar, with the difference being deposited into my savings. What type of category should I place this in? I would just list it as a transfer, but when my accounts update online, it places a charge on the checking and a deposit on the savings account. What is the best way to list this to keep track of the savings properly? Thanks for any help! In microsoft.public.money, Will wrote: > >I have a Bank of America checking and savings with ...

Custom View: Keeping worksheet hidden?
(Excel 2003) I've got a workbook with several worksheets (some hidden). I'd like to use "custom views" to basically set the print/page setup for each worksheet---the setup varies per sheet. Custom view allows me to do this, but it also unhides the worksheets. Question: Is there anyway to keep a Custom View from hidding/unhiding a worksheet? I tried saving the view with the sheet hidden and unhidden, but when I select the view, it shows everything as the view was saved. Problem is, the worksheets that are hidden are unhidden by other events....the custom view is interfering ...

Customer Payment not appearing in HQ
I just discovered an AR problem from last year where a customer made a payment at a store last year and it does not appear in HQ. I checked the Payment table at the store and in HQ, and the payment is only in the store database. On the account tab of the customer, it appears at the store, but not at HQ. How can I fix this and how could this have happened? Whoa! I also found another issue in the same account. The opposite also occurred. An account payment shows up in HQ (different amount, different date) but does not appear in the store database, even thought there is a journal r...

Automated changes of Outlook contact fields
What software / utilities / code etc. are available that would allow me to adjust some existing data in my Outlook 2003 contacts? For example, I have many "web page address" fields that need to be changed from e.g. http://subway.com to http://www.subway.com and also many "city" fields that need to be capitalized e.g los angeles to Los Angeles. Thanks in advance for any replies, Miner2049er. After some research, I believe I have to write a Visual Basic script to do this. Not knowing that language, does anybody know of a script that can do what I'm asking, or at l...

how do I change the default font in publisher 2003
I need to change the default font in Publisher 2003 from New Times Roman. I tire from changing the font every time I create anything new. >-----Original Message----- >I need to change the default font in Publisher 2003 from New Times Roman. I >tire from changing the font every time I create anything new. >. > I know they are four-letter words, but "read" and "help" should become your mainstays. Choose Help and search for "default font" The answer that you are looking for is the first listed and just waiting for you to read it. Chuck Davis &l...

Two Conditional Formats
The first conditional format is "=MOD(ROW(),2)=0". This auto shades every other row and fixs the rows color so if I do a sort the rows will still be shaded every other row. The second Conditional Format is to color the font red if less than 0. However, if a negitive number is in a row that has been shaded, the font will not trun red, in the other rows the negatives are red. What can I do to have both the shaded cell and red negative numbers? As always, any help is very much appreciated. "Ronbo" wrote: > The first conditional format is "=MOD(ROW(),2)=0&qu...

change language
Hi experts how can I change defult language(EN) a textbox in an userform to another language(ARABIC) and It back to defult in the next textbox by using VBA. Thanks in advance ...

Change Exchange server via scripting
We are going to be migrating our exchange server to another machine as part of an upgrade. Is it possible to change the users' account setup from one server to the next via a login script, or does anyone know another way to do it other than visiting each machine. Thanks, Brad Depending on the details of the migration, you might not need to do = anything at all, or this tool might be handy: = http://www.microsoft.com/downloads/details.aspx?FamilyId=3D56F45AC3-448F-= 4CCC-9BD5-B6B52C13B29C&displaylang=3Den --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 ...

Excel Formattings
I send data (percentages) to Excel with 1 decimal. The number before send to excel is 1.2%. When send to Excel the number becomes 1.20%. This is the default setting of Excel for percentages. Can anything be done in order to avoid formatting numbers again in Excel ? ...

Firing Change event from popup form
Hello, This code is on the AfterUpdate event of a list box on a popup form. Private Sub Company_AfterUpdate() Dim frm As Form Set frm = Forms![LoadSheetsMain]![LoadSheetsST].Form frm.Controls(OpenArgs) = Me.ActiveControl End Sub It assignes a value to a textbox on the calling form. I need to fire the change event of that textbox, but don't know the method. Thanks for any help. God Bless, Mark A. Sam The change event of the textbox must be Public. You can then call it from a different control or form: Forms!FormName.PublicSub Mark A. Sam wrote: >Hello, > >Th...

Button caption texts disappears after changing to Theme Windows XP
Hi, I have a simple dialog just for inputting text. This dialog has a input field, and OK Cancel button. In windows classic theme, everything is OK, but if the windows theme is changed to Windows XP, the texts on OK and Cancel buttons just disappear. The dialog's title is still there, BTW. What could be the reason? Thanks. To help your analysis, I give my codes here: #include "WhiteboardTextEntryDialog.h" #include "ComponentsID.h" #include "Data/ResourcesManager.h" BEGIN_MESSAGE_MAP(WhiteboardTextEntryDialog, SkinDialog) ON_BN_CLICKED( IDOK, onOKButto...

Office 2004 security/stability update to 11.3.4 Feb 13 changes Word version
The only difference I can find is that the version number for Word has changed from 11.3.3 to 11.3.4. Entourage and Excel remain at 11.3.3. So far, all three components play nice with OS 10.4.8 on a Dual G5 2.0 I ran the updater from the Entourage/Help/Check for Updates pulldown menu. No permissions problems were found after the update. Respectfully, Norm The 11.3.4 update is a security update and it affects three specific components of Microsoft Office 2004: Microsoft Word 2004 is updated, as are the Junk E-Mail Protection and Microsoft Component Plugin files (both of which are in Appl...

Conditional Formatting for a Range
I want to apply my formatting to an entire range. I see there are several similar questions posted already but I'm not having success with the answers provided. Here is what I am trying to do: if AC4=W4 then format A4:AC4 I cannot get this formula to apply to my entire range down to row 2000 (If AC5=W5 then format A5:AC5, and so on) -- KKD What version of Excel are you using? -- Biff Microsoft Excel MVP "KKD" <KKD@discussions.microsoft.com> wrote in message news:1AC65117-8F68-4DFF-9EBF-7F868744A9E1@microsoft.com... >I want to apply my fo...

Correction of my e-first e-mail : how to permanently customize the Default Folder option on Excel 2000 ?
Correction of my e-first e-mail : Good day dear members of the microsoft.public.excel.misc newsgroup. Please I need Your allways priceless advises. I'm working with Excel 2000 installed directly installed at the hard drive of my computer. I cannot permanently customize the Default Folder option in "Tools\Options\Default Folder\General". It works only during the current Windows session, a pc reboot would change again the Default Folder option to the former one. Is there any way to permanently customize the Default Folder option. Thank-You Octavio If you are working in a co...

Changing Transfer Category
Money 2002 Basic. I cannot find a way to change transfer transactions back to simple payment types en mass. For example, a number of transfers to a credit card account from a bank account. Can this be done via find and replace? Thanks You might want to try that. "Roger" <hansonrj@surewest.net> wrote in message news:eheQ8eTqDHA.964@TK2MSFTNGP10.phx.gbl... > Money 2002 Basic. I cannot find a way to change transfer transactions back > to simple payment types en mass. For example, a number of transfers to a > credit card account from a bank account. Can this be done vi...

MsgBox, VBA, custom
Access novice here...can someone show me (if there is a simple way) to create a message box such as vbYesNoCancel wherein I can change the text to read something else? I am able to use the standard vbMessages, but want more. I want my user to select either item 1 or item 2 or item 3 and and the attached code will respond accordingly. Thanks in advance for any help. I am not sure if there is a better way, but in the past, I have created an InputBox for such cases. I typically give the choices and explanations in the text portion of the InputBox. Then the user can enter the option t...

Quick Formatting Question
In Excel 2002, I now see the top column headers going from right to left, with the A column on the right side of the page going across alphabetically to the left. It seems like the whole orientation of the page is like this. Don't know what I did to do this, but any way to change it back to read left to right across the columns. Thanks for the help. Joe Hi Joe goto 'Tools - Options - International' and uncheck 'right to left orientation' After this: Find the colleague who did it :-) -- Regards Frank Kabel Frankfurt, Germany "Joseph" <anonymous@discus...

Union Query Formatting
Hello all, I have created a Union query to give me information from two tables and it works well, except that the formatting of a numeric field which can refer to any currency displays the default currency for everything! In the SQL statement I formatted the field to display as Standard, but of course then it becomes text! I tried writing a VAL function around it and the values were displayed in thousands, eg insted of 14,235.50 I would get 14. Help.... I've just spent hours trawling through the questions and answers on the site, but I haven't been able to find a solution. ...

change date formatting
I'm using mail merge in publisher and accessing data in access. However the data in access in showing one date format (english NZ) my regional settings are showing as (english NZ) but when the data is mailmerged into publisher it changes to a US format 10/22/05 instead of 22/10/05. I can't figure out why. If I do the same mailmerge in Office it keeps the correct format which leads me to believe its a setting in publisher but I can't seem to figure it out. HELP PLEASE!!! If you have the dates already in place in Access, changing the field to text might be the solution. Don...

How to change the row height of CListCtrl?
Dear all, Is there any method to change the row height of CListCtrl? I've looked into the ListCtrl style LVS_OWNERDRAWFIXED, through which I can get message WM_MESUREITEM from the control and then change the row height. But it is for all Items! How can I set a CListCtrl's items with different row height? Or how can I implement the behaviour of LBS_OWNERDRAWVARIABLE style CListBoxCtrl in CListCtrl? Rgds, Marco ...