Number format for basis points

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - PIVOT TABLE ALL option Is there any way to remove the "All" option that comes in the page fields in a pivot table?? Tag: Number format for basis points Tag: 138936
  - 2
    - Excel Help for Immediate Window I cannot display VBA Help for the Immediate Window using Excel 2003 under XP home. When I open Help and search for Immediate Window I get several topics. The top two, Use the Immediate Window and Immediate Window Keyboard Shortcuts do not display any information. When I click on them the machine just sits there and does nothing. All the other topics bring up a window with the topic information. Do I need to do something other than just click on either of the top two to get information displayed? Thank you. Tag: Number format for basis points Tag: 138935
  - 3
    - Cell colour according to date Hi, Is there a formula that would change the cell colour if a date in a cell was out of date afetr a set number of years. Example: Cell B9 contained date 140506 I then want the cell B9 to turn red when the date reaches 2 years later 140508. Thanks in advance Jason Tag: Number format for basis points Tag: 138929
  - 4
    - missing menus when I open excel the only thing I can see is the title bar and the cells. all the icons and menus are missing eg file, edit, insert etc how do I get the menus back thanks steve Tag: Number format for basis points Tag: 138928
  - 5
    - Footer i have following contents need to display in excel every page. anyway that can fullfill the request. I am using excel 2003 e.g contents approval by hod approval owner approval _________ ____________ ____________ audit aprroval implemented by reviewed by ___________ ______________ ____________ Tag: Number format for basis points Tag: 138926
  - 6
    - Deafult / Forced view arrangement when opening Is it possible to set a default or forced view arrangement to e.g. cascade so that and existing excel workbook automatically opens and rearranges / resizes to this mode. Most sheets I receive have been created and saved with Excel maximised and so the sheets invariably open with scroll bars running off the right and lower edges and hence have to be re-arranged Thanks Sanjay Jain Tag: Number format for basis points Tag: 138925
  - 7
    - Possible to indent the height of a row? Is it possible to apply a standard size across all rows, so that all tops and bottoms of the rows will be a specified distance from the text (similar to an indent, but from top to bottom) Thanks. Tag: Number format for basis points Tag: 138923
  - 8
    - FYI - MS Plugs 7 XL Flaws Just came across this article. http://blogs.zdnet.com/security/?p=943&tag=nl.e550 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- Tag: Number format for basis points Tag: 138922
  - 9
    - how to stop the Web and Reviewing Toolbars from randomly being Hello - It seems that excel is randomly displaying the Web Toolbar and Reviewing Toolbar---even though I never need to use either one of them. Does anyone happen to know how I can stop this from happening? Thanks. Tag: Number format for basis points Tag: 138921
  - 10
    - Converting pdf tables into Excel files Converting pdf tables into Excel files http://www.library.mcgill.ca/edrs/services/publications/howto/PDFtoXLS/PDFtoExcel.html Tag: Number format for basis points Tag: 138911
  - 11
    - How to transform a cell value that as no comma like 43534 into 435,34 Hello to ALL. I would like to know what should i use as a command or formula on Excel in order to transform a cell value that as no comma like 43534 into 435,34. Is it possible to do this in Excel? How can i do it? I use Excel 2003 SP3. Thank you in advance for any help. Best regards, Hugo Rosa Tag: Number format for basis points Tag: 138906
  - 12
    - Countif using less than or greater than criteria I have a list of data in cells d11:d15. I want to be able to count how many of the data points fall within a certain numeric range (ie less than 100 but greater than 50) but I want to be able to reference a specific cell containing the criteria rather than using '100' or '50' in the formula. In my worksheet 50 is in cell I2 and 100 is in cell K2. Tag: Number format for basis points Tag: 138902
  - 13
    - Simple countif syntax request Hi, I used to use Excel a lot but haven't for a few years. What is the syntax for using a countif function these days? "=countif(a1:a10,>b2)" used to do the trick I have tried using help but for some reason "=COUNTIF(B29:B40,">B23")" is not giving me the correct result, ie if I put 6.5 into cell b23 it is returning 0 not the number of cells in the range B29:B40 which are greater than 6.5 which is incredibly frustrating! Thanks, Will Tag: Number format for basis points Tag: 138898
  - 14
    - Data hidden/lost in Excel 2003 spreadsheet? I have an odd situation I was hoping some of you excel experts might be able to help me with. I was sent a spreadsheet (task schedule list) that was about 25kb (only 40 rows by 8 columns). After I did some editing (adding 2 new columns and adding some information to them) and saved the file, I noticed the file size has ballooned up to 2MB! I went hunting through the file to see if had accidentally pasted a something huge from my clipboard but could find nothing. I know it is the column I added as when I delete the entire column and save the file it goes back to the original 25kb. But when I delete the rows from this column where I added data (knowingly!) the file size does not change....it remains 2MB. I manually scrolled down from row 41 to 65,536 and could see nothing but white cells. I figure there's some data hidden in there but I can't seem to figure out how to find it. Can anyone recommend a good way to hunt this down? Much appreciated. Tag: Number format for basis points Tag: 138895
  - 15
    - Excel 2007 acting weird So I go into My Documents and double click an existing Excel file to open. Seems quite normal, no? This document opens, as well as a separate file "Book1". It gets rather annoying, that I've already opened the file I want. I didn't open Excel (start w/ a blank workbook) then go File>Open. Even more annoying is that I didn't make any changes to Book1 (at least that I can see), but it asks when I try to close Excel "Do you want to save?" I did have Solver installed and enabled. I've since tried disabling, but that doesn't seem to do anything. Is this normal behavior? If not, how can I stop it? TIA KenB Tag: Number format for basis points Tag: 138894
  - 16
    - Is there a way to copy a cell value into a cell comment? Is there a way to copy a cell value into a cell comment? thanks! Tag: Number format for basis points Tag: 138877
  - 17
    - When any cell in row 19 (eg K19) equals X I want the cell in row 25 3 Any tips will be greatly appreciated. Cheers! Tag: Number format for basis points Tag: 138875
  - 18
    - Can I move comment indicator to another corner of cell? In Excel 2002, those little triangular comment indicators display in the upper right corner of their cell. I want them in the U.L. corner instead. Can I tell Excel to do that? (There is no such option in Tools / Options / View's Comments panel.) Thanks. *** Tag: Number format for basis points Tag: 138870
  - 19
    - Protection from cut and paste Cell C1 is protected and has the formula A1 + B1. The users in my office sometimes cut and paste A1 and B1 to A2 and A2. After the cut and paste the formula in C1 changes to A2 + B2. What I want is for the formula to remain A1 + B1. Is there a way to protect or prevent cuts and pastes? Tag: Number format for basis points Tag: 138867
  - 20
    - send mail recipient gray (inactive) Hi I am working with excel 2007 and I added "send mail recipienton" on Quick access toolbar. and now it is gray(inactive) and I can't select it. I am using Outlook 2003. I tried this kb but it didn't work for me. My registry keys same. http://support.microsoft.com/kb/918792 What can I do for this problem Thanks... Tag: Number format for basis points Tag: 138860
  - 21
    - Largest non-blank sequence in row or column I'm trying to create a formula which will count the largest number of sequentially non-blank cells in a column or row. e.g. if the row had the following columns: |y|y|y|y| | |y|y|y|y|y|y| |y|y|y|y|y| the value would be 6 because it is the largest number of "y" values next to each other. Any Ideas please let me know. I'm using the formula to work out the longest number of days I do a particular task in a row. I update the spreadsheet daily and put a "y" in the row if I do that task. Tag: Number format for basis points Tag: 138859
  - 22
    - Heading styles in a TOC I have created some new Heading Styles for use in a document. How would I get them to be recognized in a TOC? Are there specified Styles that ONLY will work or is there a setting to get them to be recognized? Dave French Tag: Number format for basis points Tag: 138856
  - 23
    - Is this possible please Is this possible or am I asking too much of excel? If I have 254 working days in the year from D4 to D257 can it be done by a formula to work out the percentage automatically when a person is absent? It needs to know how many working days has passed in the year. Obviously up to today's date I believe it's 51 days. So, it would tell me for example that someone who has been off 10 days would have been off 5.1%. As each day passes the percentage would go down, or up if more time was taken off. It would finally tell me at the end of the year just how much time has been lost at a glance. If anyone has any ideas I would be most grateful. Bryan. Tag: Number format for basis points Tag: 138855
  - 24
    - Excel 2002 parameter query returns some blanks instead of data Hello and thanks up front... (I'm going bonkers), It's invoice time, so in my "Job Records" file, I'm using a parameter query (Excel 02, Microsoft Query) to return only those records that occur in one specified month. In the original Excel "Job Records" file on which the query is based, one column of data, labeled "PO", lists purchase order names (e.g. "VBL" for a verbal Purchase Order) or numbers (e.g. "102509"). The column is automatically formatted by Excel as "General", and I just let it ride. A second column of data, labeled "Funding Entity" lists codes - some codes are letters , others are numbers, (e.g. "GF" for Gen. Fund, "21" for 21st Fund) all formatted as "Text". When I execute the query, everything works great (the correct records, selected by month, are returned) except that the cells containing numbers formatted as "General", when returned in the "PO" column, are skipped so the resulting cell is just blank. And in the resulting "Funding Entity" column, cells containing letters (e.g. "GF") end up blank and all those containing numbers formatted as test, e.g. "21", show up just fine. So, I end up with a "PO" column containing all the entries that were "VBL", but only blanks where the entries that are numbers (formatted as "General") should be and a "Funding Entity" column containing only "21", but no "GF"s. I tried (feebly) to change the numbers formatting to "Numbers", but it didn't work. Anyone know where I went wrong? Tag: Number format for basis points Tag: 138854
  - 25
    - Get Column Header from Match in a Array? Here's what I am trying to do. I have a table of date, with the column names in Row 1, Column B-J. The Data from B2:J11 is dates. On a second sheet, I have the dates listed chronologically, I'd like to use a formula to take at the date in the second sheet, and look at the array on the first sheet and tell me what column it is in - or give me the text value from row 1 in that column. Tag: Number format for basis points Tag: 138852
- Next
  - 1
    - =?Utf-8?Q?Loosing_formula_when_changing_ro?= Iâ??m stymied and could use some help. I have a file that contains data in Sheet1 A1:A3 with values a,b,c. In Sheet2 B1:B3 I reference Sheet1â??s data with =Sheet1!A1 and so on. In Sheet2 if I try change the row reference from A1 to A2 I donâ??t get the value, I get the formula displayed =Sheet1!A2. The problem is that I have 2 columns like this and one works with reference changes the other doesnâ??t. I have checked cell formatting and option settings in all cells and they are all identical. The only clue Iâ??ve seen is that before the attempted change I can still do a precedent trace but after changing the row # to a valid row the trace indicates that the cell doesnâ??t â??contain a formula with a valid referenceâ??. The formula/link is getting clobbered, but I can find no settings that would effect that and would appreciate any hints. Tag: Number format for basis points Tag: 138848
  - 2
    - Automatically add calendar events? Using the powershell, is there a way to add calendar events to specific mailboxes? Our vacation time request system is a home grown web-based application. We'd like to configure it so that once the vacation time has been approved, the requesters Outlook calendar would then automatically be populated with "out of office" entries for the days off they requested. Thanks in advance! Tag: Number format for basis points Tag: 138847
  - 3
    - Auto sorting? Auto lock? --____QVNHWPNZZYRFJGJPVEVF____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 08:26:31 -0500" SSBoYXZlIGEgd29ya3NoZWV0IGluIHdoaWNoIEkgZW50ZXIgZGF0YSB1bmRlciA4IHRpdGxlZCBj b2x1bW5zLiBBZnRlciBlbnRlcmluZyBpbmZvIG9uIHRoZSA4dGggYW5kIGZpbmFsIGNvbHVtbiwg SSB3b3VsZCBsaWtlIGZvciBleGNlbCB0byBzb3J0IGJ5IGNvbHVtbiAxLCB3aGljaCBpcyB0aGUg ZGF0ZSwgYW5kIGFsc28gbG9jayB0aGUgcm93LCBzYXkgcm93IDI0LCBwcmV2ZW50aW5nIG1pc3Rh a2VzIG9uIHByZXZpb3VzbHkgZW50ZXJlZCB0cmFuc2FjdGlvbnMuIElmIGFueW9uZSBrbm93cyBo b3cgdG8gaGVscCwgSSB3b3VsZCBkZWZpbml0ZWx5IGFwcHJlY2lhdGUgaXQuDQoNCkRhdmlk --____QVNHWPNZZYRFJGJPVEVF____ Content-Type: multipart/related; boundary="____UTWYPPFWWFEFDBBPDCPN____" --____UTWYPPFWWFEFDBBPDCPN____ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 08:26:31 -0500" PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z MjY4IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4 IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5JIGhhdmUgYSB3b3Jrc2hlZXQgaW4gd2hp Y2ggSSBlbnRlciBkYXRhIHVuZGVyIDggdGl0bGVkIGNvbHVtbnMuIEFmdGVyIGVudGVyaW5nIGlu Zm8gb24gdGhlIDh0aCBhbmQgZmluYWwgY29sdW1uLCBJIHdvdWxkIGxpa2UgZm9yIGV4Y2VsIHRv IHNvcnQgYnkgY29sdW1uIDEsIHdoaWNoIGlzIHRoZSBkYXRlLCBhbmQgYWxzbyBsb2NrIHRoZSBy b3csIHNheSByb3cgMjQsIHByZXZlbnRpbmcgbWlzdGFrZXMgb24gcHJldmlvdXNseSBlbnRlcmVk IHRyYW5zYWN0aW9ucy4gSWYgYW55b25lIGtub3dzIGhvdyB0byBoZWxwLCBJIHdvdWxkIGRlZmlu aXRlbHkgYXBwcmVjaWF0ZSBpdC48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkRhdmlk PC9ESVY+PC9CT0RZPjwvSFRNTD4= --____UTWYPPFWWFEFDBBPDCPN____-- --____QVNHWPNZZYRFJGJPVEVF____-- Tag: Number format for basis points Tag: 138844
  - 4
    - Unexpained Shortcut to Personal.xls I have Office 2003's Excel set up on my desktop and my laptop under XP Home. They both work as expected. Personal.xls is in Program Files\Microsoft Office\OFFICE11\XLSTART on both machines. However, on the Desktop alone there is a shortcut to it in Documents and Settings\Main\Application Data\Microsoft\Excel\XLSTART. I delete the latter and open Excel and all the macros in Personal.xls that are tied to buttons and menu items work just fine without the shortcut. But when I close Excel, the shortcut reappears in Documents and Settings\Main\Application Data\Microsoft\Excel\XLSTART. This does not happen on the laptop. There must be something in the way I have the two Excels set up. The laptop has my name as the user name and the desktop has Main as the user name. This is the only difference I am aware of. This does not cause any problems that I can see but I am curious about why it should happen on one machine and not the other. I will appreciate any guidance on this riddle. Thank you. Tag: Number format for basis points Tag: 138837
  - 5
    - Please help: opening a datastream comma delimited Hello Anyone help? I'm trying to open a data stream in excel from my own remote server which uses comma delimitation and I'm trying to get Excel to open as such, instead of sticking all the data in one column. Someone suggested the code below might work from but on 'startrow' it throws up a 'compile error' that 'named argument is not found'. Anyone have an idea how to do it? I'm no expert. Workbooks.Open Filename:="http://x.x.x.x:8085/ppui/resultscsv?CUSTOMER=BOOKINGID=8165806", Origin:=437, Startrow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True Tag: Number format for basis points Tag: 138828
  - 6
    - Adding like occurences I can't figure this one out and need help. Sheet1 has names in col 1 and values in col 2 - I want to add totals together for everytime a certain name is found in col 1 in the sheet 2. (Name is listed multiple times on sheet 1) This is easy but I can't remember how to do it! Thanks for any help provided. Annette Tag: Number format for basis points Tag: 138823
  - 7
    - Drop-down lists --____APTVTIKANCHSADEVXJRW____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 04:16:00 -0500" SXMgdGhlcmUgYW55d2F5IHBvc3NpYmxlIHRvIGNyZWF0ZSBhIERyb3AtZG93biBsaXN0IHRoYXQg aW5jbHVkZXMgdGhlIGRhdGVzIG9mIG9ubHkgdGhlIGN1cnJlbnQgbW9udGg/IElmIGl0J3MgTWFy Y2ggSSB3b3VsZCBsaWtlIGNvbHVtbiBBIHRvIG9ubHkgaGF2ZSBNYXJjaCAxc3QgdGhyb3VnaCB0 aGUgMzFzdCB0byBiZSBwb3NzaWJsZSBlbnRyaWVzLiBXaGVuIGl0IGJlY29tZXMgQXByaWwsIHRo ZW4gQXByaWwgZGF0ZXMgYXJlIG9ubHkgb25lcyBhbGxvd2VkLCBhbmQgc28gb24uIElmIHNvbWVv bmUgY291bGQgaGVscCB0aGF0IHdvdWxkIGJlIGdyZWF0IQ0KDQpEYXZpZA== --____APTVTIKANCHSADEVXJRW____ Content-Type: multipart/related; boundary="____KWGZCTCLPZSFANYZDVPO____" --____KWGZCTCLPZSFANYZDVPO____ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Wed, 11 Mar 2008 04:16:00 -0500" PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z MjY4IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4 IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5JcyB0aGVyZSBhbnl3YXkgcG9zc2libGUg dG8gY3JlYXRlIGEgRHJvcC1kb3duIGxpc3QgdGhhdCBpbmNsdWRlcyB0aGUgZGF0ZXMgb2Ygb25s eSB0aGUgY3VycmVudCBtb250aD8gSWYgaXQncyBNYXJjaCBJIHdvdWxkIGxpa2UgY29sdW1uIEEg dG8gb25seSBoYXZlIE1hcmNoIDFzdCB0aHJvdWdoIHRoZSAzMXN0IHRvIGJlIHBvc3NpYmxlIGVu dHJpZXMuIFdoZW4gaXQgYmVjb21lcyBBcHJpbCwgdGhlbiBBcHJpbCBkYXRlcyBhcmUgb25seSBv bmVzIGFsbG93ZWQsIGFuZCBzbyBvbi4mbmJzcDtJZiBzb21lb25lIGNvdWxkIGhlbHAgdGhhdCB3 b3VsZCBiZSBncmVhdCE8L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkRhdmlkPC9ESVY+ PC9CT0RZPjwvSFRNTD4= --____KWGZCTCLPZSFANYZDVPO____-- --____APTVTIKANCHSADEVXJRW____-- Tag: Number format for basis points Tag: 138821
  - 8
    - Recipies of South INDIA Do you want to know to how to make mouthwatering,spicy foods? If you want to know how to make delicious South Indian foods please visit http://recipesoftamilnadu.blogspot.com/ Tag: Number format for basis points Tag: 138820
  - 9
    - time line in chart Hi How do I put a vertical line in a chart in excel at a given point? i.e. timeline Thanks Jon Tag: Number format for basis points Tag: 138817
  - 10
    - Pick several numbers from a list to get as near as possible to required total I have a list of several hundred policies each with a different value. Occasionally I have a request to 'sell off' policies to a certain value. At the moment I manually select policies from the list till I get 'close enough' to the total. Is there a way of automating this and getting the closest result possible? To put numbers to my problem above, suppose I have the following 9 policies 1 $11,234.67 2 $604.50 3 $7,632.00 4 $5,638.76 5 $16,345.98 6 $23,678.43 7 $15,678.44 8 $1,007.17 9 $53,713.97 I get a request to sell of $54,500 worth, at a glance I would probably select policies 8 & 9 (totaling $54,721.14), where as infact policies 3, 4, 5, 6 & 8 would be a better choice as they total $54,302.54 All help would be much appreciated Gerry Tag: Number format for basis points Tag: 138815
  - 11
    - Excel 2007 - Conditional Formatting copy/paste errors I find that if I create a conditional format at one cell and then copy that to a multitude of others, the variable references within the conditional format will not adjust accordingly. For example: At cell A1, I have the conditional format of "=IF(A1>0,1,0)". If I copy this to cell B2:B3 (in one stroke), I will find both cell B2 and B3 to have the same formula "=IF(B2>0,1,0)". This of course is fine for cell B2, but it is not fine for cell B3. I would expect cell B3 to reference itself; not cell B2. Another problem is that if the receiving cells should have a conditional format previously in place, the copy from A1 to B2:B3 will append to the preexisting conditional format as opposed to overwriting them. The only circumvention I have for this bug is to clear any possible conditional format before I paste to the receiving cells, B2:B3. So, how do I resolve this apparent bug in Excel? btw, this bug is not present in Excel 2003. Thanks, Bob. Tag: Number format for basis points Tag: 138813
  - 12
    - match and index function - getting it to keep its original reference I am using the match and index function to pull in data from a separate worksheet. I am using Column A as the reference cell, whereas my formula lies in Column F. The formula pulls in the data fine. The problem is, when I sort the data set, the match index function maintains the original reference cell and does NOT refer to the same row. So, for example, if my formula references A3, the formula continues to use A3 after I sort the cell (as if I had used an absolute reference). Does anyone know how to fix this? How can I pull in data using matchindex (or vlookup), but also be able to sort the rows without messing the formula up? Is there a way to use a list or named ranges to accomplish this? The actual formula I am using (in case it helps) is: =IF(ISNA(INDEX(CMS2!I:I,MATCH('CPT Summary for CMS Comp'!A27,CMS2! A:A,FALSE))),0,INDEX(CMS2!I:I,MATCH('CPT Summary for CMS Comp'! A27,CMS2!A:A,FALSE))) Thanks for any suggestions. Tag: Number format for basis points Tag: 138810
  - 13
    - Show leading zeros (eg: 000123) When I import a file that originally had numbers such as "000123" in excel, the number only shows 123. Is there a way for me to get the cell to show 000123? Thanks Tag: Number format for basis points Tag: 138809
  - 14
    - adding a leading 00 to some loan numbers I've got several thousand loan numbers which need to be updated to a ten-digit format by adding a leading 00. That's easy enough to do, HOWEVER, some of them have already been updated with the leading 00. What formula can I use to add 00 only to those which have not already been updated? Thanks. -- alan Tag: Number format for basis points Tag: 138799
  - 15
    - Counta not calculating correctly??? Count anyone shed some light on this issue. I am using the statement n = WorksheetFunction.CountA(Cells(i, 13), Cells(i, 17), Cells(i, 22)) I am trying to get a value for how many of the 3 cells have data in them. While watching my n count I am seeing it reading 2 when there is clearly only data in one of the cells. Any idea why this would be reading incorrectly? Thanks for any help -- KWB Tag: Number format for basis points Tag: 138779
  - 16
    - e-mail addresses Hi Everyone I am having a problem with e-mail address in excel spreadhseet. Some of them go in, in black the same as the rest of the spreadsheet, but others show up in BLUE and then they are clickable. I would just like them all in black. What should I do, or what an I doing wrong? Thanks Donna Tag: Number format for basis points Tag: 138771
  - 17
    - how to create an excel template I am having problems trying to create an excel template. I took a xlt file. and put it in the dir C:\Program Files\Microsoft Office\Templates\1033 However I do not see it ever showing up in the file>new>on my computer is there something special you have to do? thanks Tag: Number format for basis points Tag: 138761
  - 18
    - How to add SAMPLE ONLY overlay? Hi - how do I add 'SAMPLE ONLY' diagonally across a tab and have it somewhat transparent? I've tried pasting in a jpg of SAMPLE created using Viso, but that background of the pic is not tranparent. Pete Tag: Number format for basis points Tag: 138758
  - 19
    - Selecting a folder to save xml to... I have the following code that works fine in Excel 2003 and I am looking for something similar that will produce the same result but for Excel 2000 can anyone help? If xmlfolder = "" Then MsgBox "Select folder for the XML file", vbCritical With Application.FileDialog(msoFileDialogFolderPicker) .Title = "SELECT FOLDER" .AllowMultiSelect = False ' Folder selected If .Show = -1 Then xmlfolder = .SelectedItems.Item(1) & "\" End If Regards Jamie Tag: Number format for basis points Tag: 138755
  - 20
    - Autofilter - No. of Rows Does anyone know of any way to increase the number of rows displayed in Autofilter, becauase when working on large ranges it doesn't display all values. Any help greatly appreciated..... Tag: Number format for basis points Tag: 138754
  - 21
    - Startup Hello My Excel VBA is sometimes used by other people, and they ara "abusing" my codes by using toolbar commands. I want to make Excel VBA and to hide / disable all toolbars and any other Excel command. I want that only my buttons can be used. Beforehand thanking for any help,7 Sb. Tag: Number format for basis points Tag: 138753
  - 22
    - flip columns to rows Is there any way to 'flip' a worksheet with one command, so that columns become rows (or rows become columns)? Tag: Number format for basis points Tag: 138748
  - 23
    - Outsourcing Data Entry 100% guaranteed or your money back Data Entry Outsourcing Services ensures high quality, result oriented in time. We promise to deliver excellent output at low turn around times and cost-effective rates. Our dedicated team of highly experienced professionals to provide you high quality outsourcing services. Do visit us at http://www.dataentryoutsourcing.co.uk/dataentry_services.php, to know more about our Data Entry Outsourcing Services and avail our services at affordable rates. Data Entry Outsourcing provides data entry services like numeric data entry, textual data entry, image data entry, data format, data conversion and also online data entry, offline data entry with 99.98% accuracy and time bound. Data Entry Services also provides form data entry, data capture, HTML/ SGML coding, image scanning, file conversion with low cost, high quality, time bound and high data security. By taking advantage of Data Entry Outsourcings domain knowledge, quality processes, high-tech infrastructure, and global delivery options, clients are able to perform better while allowing them to concentrate on their core competencies. Based in U.K., Data Entry Outsourcing operates from offshore multiple production centers in India. Contact us for more information about Data Entry Services. E-mail Us: info@dataentryoutsourcing.co.uk Phone (India): +91-794-000 3000 Fax : +91-794-000 3002. Tag: Number format for basis points Tag: 138745
  - 24
    - Remove Final Character from Cell. Hi All, I am trying to remove the final character from a cell with a find and replace. the cell contents are like the following example. 07APR07A needing to be 07APR07 But other cells in the list are already in the format of 07-Apr-07 07APR07* I have managed to remove the * by using the tide ~ character. So I don't know if there is a similar character to remove the last character only. But am stuck with the last character. Can someone please help. Tag: Number format for basis points Tag: 138741
  - 25
    - runtime error '429' activex component can't create object We recently moved to "visual studio 2008" . Our addin workd find on our development machine which has Excel 2003 and Excel 2007. When we create the installation package and install onto a machine with only Excel 2003 we get the "runtime error '429' activex component can't create object". Any ideas please. Thanks in advance Tag: Number format for basis points Tag: 138738

Hello

I am certainly not the first to ask but I didn't find an answer yet.
Is there anyway to create a custom number format that allows to
display basis points in Excel?

For instance if I have a cell with the formula "=2.5%%", I would like
to see "2.5bps" appearing.

"0.0%%" allows to get "2.5%%" appearing. Any trick to get beyond that
step?

thanks in advance
Charles

Re: Number format for basis points by Bob

Bob
Thu Mar 13 11:57:38 CDT 2008

Use a custom number format of 0.0"bps" and just enter 2.5

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Charles" <spam@cmichel.net> wrote in message
news:81ee270f-3095-455a-a300-685ea54da384@u10g2000prn.googlegroups.com...
> Hello
>
> I am certainly not the first to ask but I didn't find an answer yet.
> Is there anyway to create a custom number format that allows to
> display basis points in Excel?
>
> For instance if I have a cell with the formula "=2.5%%", I would like
> to see "2.5bps" appearing.
>
> "0.0%%" allows to get "2.5%%" appearing. Any trick to get beyond that
> step?
>
> thanks in advance
> Charles

Re: Number format for basis points by Nick

Nick
Sat Mar 15 08:16:27 CDT 2008

Bob Phillips wrote:
> Use a custom number format of 0.0"bps" and just enter 2.5
>

I think he is looking for something similar to % but that multiplies the
number by 10,000 instead of 100.

I've had to do it in apps. I can't remember seeing it done in excel.

Re: Number format for basis points by Charles

Charles
Mon Mar 17 06:14:42 CDT 2008

Bob Phillips wrote:
> I've had to do it in apps. I can't remember seeing it done in excel.

I guess that answers my question. Thanks!

Charles