Phantom spaces after decimal point.

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
    - INDEX and 2 MATCHES (of which 1 variable) Hello, I'm stucked with the following: I try to retrieve a result (column C)via a combination of a INDEX and two MATCH functions, the first MATCH needs to be matched exactly but the second MATCH has to be defined as the closest match. Sample: A B C 1 January 2005 Low Forecast PE <V,Lcl> 5 2 January 2005 Small Cap <S,lcl> 6 3 January 2005 High EBIT/EV <V,Lcl> 7 4 February 2005 Low Forecast PE <V,Lcl> 5 5 February 2005 Small Cap <S,lcl> 6 6 February 2005 High EBIT/EV <V,Lcl> 7 As the values in column B differ, it is desirable to look at the desciption without the brackets (i.e. Low Forecast). Which formula gives me the result in column C when machting the following: 1. January 2005 2. Low Forecast <V> For the sake of completeness I would like to underline that the fixed description is i.e. Low Forcast <V> but that the desciption in the above summary one time is <V> and the other time <V,Lcl>. Hope that someone can tell me which formula to use. Thanx in advance Rgds, Robert Tag: Phantom spaces after decimal point. Tag: 64135
  - 2
    - hi mertus145@aol.com Tag: Phantom spaces after decimal point. Tag: 64130
  - 3
    - How do I enter conditions How do I enter conditions like: If A1 is <0.2 and A2 is >or = 0.2 then A3=Negative If A1 is >0.2 but <2.0 and A2 is Anything then A3 is IND. If A1 is > or = 2.0 and A2 is Anything then A3 is Positive. and get them to work? I would need all 3 conditions in a single cell. Is this possible? Tag: Phantom spaces after decimal point. Tag: 64129
  - 4
    - test dwassenaar@cypresscollege.edu Tag: Phantom spaces after decimal point. Tag: 64126
  - 5
    - test nehlen@socal.rr.com Tag: Phantom spaces after decimal point. Tag: 64120
  - 6
    - Heading rows repeat in word embedded excel table I have embedded an excel table in word and I want to make the top row o the table appear on every page if the table spreads on to more pages. know how to do it in word, you use: Table>Heading Rows Repeat, but th tables column is missing when I selected the embedded table, what can do -- Turnipbo ----------------------------------------------------------------------- Turnipboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2452 View this thread: http://www.excelforum.com/showthread.php?threadid=38151 Tag: Phantom spaces after decimal point. Tag: 64118
  - 7
    - address formula on SHEET1 A1 I HAVE A FORMULA =SUMPRODUCT(--(B1:B9999=X) on SHEET2 A1 I HAVE A ,--(C1:C9999=O)) HOW CAN I LINK THIS TWO SHEET, IF CHANGE THE DATA ON SHEET2 A1 LIKE THIS>>> ,--(C1:C9999=P)) THE FORMULA OF SHEET1 A1 WILL BE >>>> =SUMPRODUCT(--(B1:B9999=X),--(C1:C9999=P)) TNX IN ADVANCE GOD SPEE -- xtrmhype ----------------------------------------------------------------------- xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2385 View this thread: http://www.excelforum.com/showthread.php?threadid=38151 Tag: Phantom spaces after decimal point. Tag: 64117
  - 8
    - clear the error hi, i wrote a formula on range from a1 to e13, the result would be shown on k1:k13 but the cell were shown on the #DIV/0! because i knew that the some cell has not yet put the data. I really know how to clean it or replace by 0. please help thanks jimmy Tag: Phantom spaces after decimal point. Tag: 64116
  - 9
    - Can I change Column Header Names? Hi All.. Can I change Coulmn Header Names... What I mean to say that , We Have Generally Column Names A, B, C, D, ... I would like to Change these names what ever I Want.. Any help would be Appreciate... Thanx ina Advance... Zameer ahmed syed email : zameer_india@yahoo.com : zameer@icoachmath.com -- zameer_india ------------------------------------------------------------------------ zameer_india's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24559 View this thread: http://www.excelforum.com/showthread.php?threadid=381504 Tag: Phantom spaces after decimal point. Tag: 64114
  - 10
    - How to write an EMPTY cell? As part of a formula (or as part of Copy->PasteSpecial, I need to overwrite a column of cells with either data or leave empty. Example, =(if a<>b,c,"") - where c is a number - doesn't work because it puts a blank in the cell. Example, =(if a<>b,c,0) - where c is a number - doesn't work because it puts a zero in the cell. I don't want to use Tools->Options to show the cells as empty rather than 0.00 because that will be so for the whole sheet, not just the one column I am worrying about. I am trying to update a protected sheet automatically from a second sheet and only the 2 columns I am supposed to enter data into are unprotected (can be changed). I have the whole thing working now with a macro except for the cells which are supposed to remain empty. If I use "" then it messes up a subsequent formula, and if I use 0 then it looks wrong (I want to place the value in each cell of the column only if it meets a certain condition, else leave it empty. Is there a way to make a cell empty as opposed to just looking empty? I tried to replace all 0 with <delete key> but that didn't work ... Looking for ideas ... TIA Fran Tag: Phantom spaces after decimal point. Tag: 64107
  - 11
    - shifting values I have 100+ rows each with 6 cells (A-F) A & B contain variables which may or may not change daily and C-F have values produced as follows: C=A*B, D equals what was previously in C, E=what was in D, F=what was in E, what was previously in F doesn't matter. Can a formula be written to shift the values from one cell to the next or does this have to be done manually everytime a variable changes? Thanks for your help. CB -- ChinaBoat ------------------------------------------------------------------------ ChinaBoat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24557 View this thread: http://www.excelforum.com/showthread.php?threadid=381491 Tag: Phantom spaces after decimal point. Tag: 64106
  - 12
    - Column of Dates - Mondays to Friday for a year Is their a way to get a column of dates for Monday, Tuesday . . .. Friday for a calendar year ? Thanks Tag: Phantom spaces after decimal point. Tag: 64099
  - 13
    - Detect Colours Hi A Colleague has just asked me if there is any way, without using VB to detect font colours by using an IF statement formula. ie. He has created a sheet that if a user changes a cell then the cell that is changed turns red. He would like to detect this change by using a formula. I suspect this is not possible but if it is could somebody please pass on an example? Thanks in advance Shaun -- ShaunM ------------------------------------------------------------------------ ShaunM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18610 View this thread: http://www.excelforum.com/showthread.php?threadid=381460 Tag: Phantom spaces after decimal point. Tag: 64097
  - 14
    - Setting up pages in a workbook I have just created hundreds of workbook pages with different data. What I would like to know is how do I set up every page to be in the same format without having to do each one separately? :eek: Thanks ahead of time. -- calimari ------------------------------------------------------------------------ calimari's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24537 View this thread: http://www.excelforum.com/showthread.php?threadid=381449 Tag: Phantom spaces after decimal point. Tag: 64094
  - 15
    - Copy from many cells and paste to one I need to copy a range of cells (C7:C20) and past the contents into one cell (B4). the concatenate function is not the solution because I need the results to appear as separate lines in the cell (B4) when pasted. (leaving a "return" between lines) Weird I know but Ahem, "It's for a friend". ;) Thanks, Robert -- eoreality ------------------------------------------------------------------------ eoreality's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24549 View this thread: http://www.excelforum.com/showthread.php?threadid=381448 Tag: Phantom spaces after decimal point. Tag: 64091
  - 16
    - Web publishing a spreadsheet I have saved a workbook as an Web htm that is now on my hardrive as C:/documents and settings/workbook.htm. What do I send to others to view this workbook and can I see their updates??? -- lcannon ------------------------------------------------------------------------ lcannon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24253 View this thread: http://www.excelforum.com/showthread.php?threadid=381411 Tag: Phantom spaces after decimal point. Tag: 64078
  - 17
    - Answer to my question I received an e-mail stating a community member had responded to my question titled "...". But I can't find the answer or reply. Please help. Tag: Phantom spaces after decimal point. Tag: 64072
  - 18
    - Is there a way to copy and paste the date into worksheets Is there a way to copy and paste dates into the worksheet withou individually typing up each one -- mark_vi ----------------------------------------------------------------------- mark_vi_'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2450 View this thread: http://www.excelforum.com/showthread.php?threadid=38137 Tag: Phantom spaces after decimal point. Tag: 64064
  - 19
    - Dataformatting Hi, Is it possible to import a number of rows (data) from Access, and then have Excel automatically display these data in every third row - leaving two rows blank between them? If so, it would really make my day. Regards Jan -- dotonline ------------------------------------------------------------------------ dotonline's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24545 View this thread: http://www.excelforum.com/showthread.php?threadid=381379 Tag: Phantom spaces after decimal point. Tag: 64063
  - 20
    - Changing values in a value box Hi all, I have a data set that looks like this: DATE A$ B$ A% B% mar-14 50 100 33 66 mar-21 100 100 50 50 mar-28 75 25 75 25 I want to chart the percentages by each date, but I want the "value" box to display the dollars. The only way I can think to trick the Excel chart is create 2 x-axises and hide the $ axis, but then the $ values don't match the height of the % columns. Is there a way to link the $ values to the % columns? Thanks. Tag: Phantom spaces after decimal point. Tag: 64034
  - 21
    - Excel-Powerpoint interface Is there a way to use Excel live within a Powerpoint slide? Fo instance, can a spreadsheet be embedded in a Powerpoint presentation s that a working computation input/output box is visible in the slide a it's being presented? I'd like to be able to change pricing on the fl as I'm showing the customer, but not have to switch back and forth t Excel to do it -- tsunderlan ----------------------------------------------------------------------- tsunderland's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2453 View this thread: http://www.excelforum.com/showthread.php?threadid=38130 Tag: Phantom spaces after decimal point. Tag: 64033
  - 22
    - Spreadsheet pages Can anyone tell me how many sheets can you have per workbook? I als need to know how to combine one spreadsheet with another. Thank you in advance. : -- calimar ----------------------------------------------------------------------- calimari's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2453 View this thread: http://www.excelforum.com/showthread.php?threadid=38130 Tag: Phantom spaces after decimal point. Tag: 64032
  - 23
    - Problems with programs, help files, excel, on partitioned hard drive Good Morning, Not sure where to post or where to start with this one. I have a hard drive with several partitions. Windows 2000 and IE are on the C: partition and everything else is in it's own partition. So Office 2000 is installed in the "Program Files" Partition and "My Documents" and other data folders have their own partitions. I used TweakUI to make sure everyone knows where they are. Everything works fine except for help files and maybe some stuff in Excel's VBA editor (such as certain scripts not being able to run properly). The help files I'm sure about though. The Windows help files don't even show up. I can select a topic from the index but then I get nothing; maybe an IE error page. Thankfully, I'm able to read most of the Excel help files but none of the links show up. I get empty placeholders instead. This is a relatively new install and I'm not sure what is causing the problem but my main suspect is the partitioning of the hard drive. If anyone could shed some light on this problem I would really appreciate it. Thanks, Laylow "Unless someone like you cares a whole awful lot, nothing is going to get better. It's not." -Dr. Seuss Tag: Phantom spaces after decimal point. Tag: 64030
  - 24
    - Copy and pasting columns that are not adjacent Is there a way to copy and paste columns that are not adjacent i.e. the are on the same rows but there are columns in between that I do not wan to copy (and do not want to move adjacent) - they are to go into autoca as an embedded file. What if the columns are not on the same rows, ca you still copy and paste seperate parts of a spreadsheet in one go/fil -- Turnipbo ----------------------------------------------------------------------- Turnipboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2452 View this thread: http://www.excelforum.com/showthread.php?threadid=38126 Tag: Phantom spaces after decimal point. Tag: 64026
  - 25
    - Autofilter not appearing correctly? help! Hey all. I copied a large spreadsheet into a new worksbook and hence new sheet. This sheet was then customised for the user ..I got rid of un-necessary rows within the this new customised spreadsheet that user would not require. The autofilter in the original large spreadsheet shows many different options when the drop down button is clicked... whilst the sheet that ive created which was mostly copied does show the autofilter but shows no additional options..it only shows the options: "All", "Top 10" and "Custom". Why is this? Am i making any sense?!?!?! -- londonchick ------------------------------------------------------------------------ londonchick's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24529 View this thread: http://www.excelforum.com/showthread.php?threadid=381272 Tag: Phantom spaces after decimal point. Tag: 64025
- Next
  - 1
    - Adding numbers in column if yes is written to right I have a column of numbers which I what to sum, which i straightforward. However I also want to sum only those numbers in th same column which have 'Yes' written in the cell to the right, whic only some have. How would I do this -- Turnipbo ----------------------------------------------------------------------- Turnipboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2452 View this thread: http://www.excelforum.com/showthread.php?threadid=38123 Tag: Phantom spaces after decimal point. Tag: 64023
  - 2
    - Large excel file problems? I have a very large Excel file, about 6mb. The main cuase of that siz is about 20 columns by 8192 rows of data and formulas analyzing tha data (yes..I am afraid that is as compact as I can get it). The othe causes for the size are a lot of formatting, color, text, etc, but I a sure most of it is all the formulas. With the file size being 6mb, i there anything to worry about as far as expecting Excel crashes, o anything of that sort? I am using Excel 97, by the way. Thank you -- gkast ----------------------------------------------------------------------- gkaste's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2452 View this thread: http://www.excelforum.com/showthread.php?threadid=38123 Tag: Phantom spaces after decimal point. Tag: 64022
  - 3
    - Cant click button immeditally After typing into a cell, I cannot click on a button right away. First I have to hit enter(or do something to move to another cell), then I ca click on the button. Is there any way around this? Reason being tha this spreadsheet was designed for use by some no so computer savv people, and when they cant click the button, I dont know what the think will fix it, but somehow they delete something and goof up th spreadsheet. Is there a way to change this so clicking the butto deactivates the cell, or something like that? Thank you -- gkast ----------------------------------------------------------------------- gkaste's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2452 View this thread: http://www.excelforum.com/showthread.php?threadid=38123 Tag: Phantom spaces after decimal point. Tag: 64021
  - 4
    - conditional named dynamic ranges I've use the offset function with great success to define named dynamic ranges, but I'm now trying to only include certain rows in the range. The formula I use currently looks like this: =OFFSET('NARD Listing'!$A$1,0,0,COUNTA('NARD Listing'!$A:$A),8) but I am unable to figure out how to only include rows that have '2005' as a value in column D, as an example, in the named range. thanks for any help! Matthew (using Excel 2000) Tag: Phantom spaces after decimal point. Tag: 64012
  - 5
    - Help with slow loading and recalculation of work books. I have created workbooks to analysis data for my fishing. There are 12 workbooks (each containing 48 sheets), one workbook per year for the last 12 years, each approx. 12,600KB. Each years workbook is linked to the following years workbook by some 1000+ cells. The data is fed into these workbooks from 2 associated workbooks, one of approx. 10,700KB and another of approx. 2,150KB. All the workbooks contain numerous volatile calculations using TODAY() and many of the sheets within the 12 yearly workbooks contain INDEX/MATCH lists of data either from within the workbook of from the 2 associated workbooks. I an running windows 98 second edition and Excel 97 on a computer with a Pentium II processor. The hard drive is 6137MB(FAT32) of which just over half is available space. I have 192MB RAM. I have looked through http://www.mvps.org/dmcritchie/excel/slowresp.htm and have done what I can to solve slow response of loading and calculation. To load each of the yearly workbooks together with recalculating links takes between 1-2 minutes and I can only load 2 workbooks (attempting to load a 3rd results in an out of memory message). It would be an advantage if I could load up to 3 workbooks at a time but, this is not essential. However I would like to be able to speed up the loading and calculation. Would an increase in memory help with this and if so, how much improvement in loading and calculation time could I expect to achieve? Any help would be gratefully received. -- John Bedford Delete extra @ to reply. Tag: Phantom spaces after decimal point. Tag: 64011
  - 6
    - Drop down list error after edit I am using a drop down list to describe the type of work that I want to bill for.Is it possible to add a comment or edit this desription once it is displayed. Right now when I attempt to change/add info; I get a error message and can not complete my edit. Is there a way around this? Tag: Phantom spaces after decimal point. Tag: 64009
  - 7
    - Is this Conditional Sum task I'm using Excel 97 :( Is there an easy route so that all entries in a {numbers} column, are converted to a figure that always divisible by "3" in this case ie the outer quantities of this particular product. Thanks a lot :rolleyes: -- fyrnetics ------------------------------------------------------------------------ fyrnetics's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12558 View this thread: http://www.excelforum.com/showthread.php?threadid=381182 Tag: Phantom spaces after decimal point. Tag: 64004
  - 8
    - Countif Hi Is it possible to use the function, Countif in a macro? I get a function not defined error when trying: res=Countif(range,k) Charles Tag: Phantom spaces after decimal point. Tag: 64001
  - 9
    - Three choice user input from form Hi, have posted similar question before but need to clarify it. I need a user form (got this far) that gives the user three choices. One is a unique product number (200) coloumn A, the second is a location (9 altogether) sorted in column B and the third a date (in the top row). I need to capture this preset data from the user form and then add a fourth entry (a number) into the cell chosen from the first three choices. Product # Location date1 date2 date3 date4 1 a x x x x 1 b x x x x 1 c x x x x 1 d x x x x 2 a x x x x 2 b [and so on] x indicates the target cell for the user form. Yes, it should be a database but there you go. Thanks in advance for the help J Tag: Phantom spaces after decimal point. Tag: 63998
  - 10
    - color printing embedded worksheet Hi, I have a worddocument with a number of embedded excel tables in them. The problem is that these excel tables are not printed in color, although the printpreview displays them in colors. The word document itself contains colored words, and they print in color just fine. Any ideas ? I run Office XP-sp3 Ward Tag: Phantom spaces after decimal point. Tag: 63996
  - 11
    - Way to Link Tab Names I checked this out a few years ago, but thought I might post for an updated answer. I have a few workbooks linked together and would like to know if there is a way to create an absolute reference between linked tabs regardless of the name of the tab. As new projects are started, tabs get renamed, so we have to have all the workbooks open at once to keep the links active. Maybe there is a way to name the tab to a linked cell, so as a workbook is opened, it looks at the linked cell name for the tab name first to keep the links active? It would also have to work around tabs getting relocated, so references to Sheet1, Sheet2, would probably not work, which is why I thought a cell reference would work around that issue. Thanks! Tag: Phantom spaces after decimal point. Tag: 63992
  - 12
    - Extract Unique Values, Then Extract Again to Remove Suffixes I have a list of builders where I want to extract all the unique values. Using =IF(COUNTIF($A$1:A1,A1)=1,A!,"") works fine to get the first set of unique values, but I need to extract it a bit further. The builder names may be Ryan 50, Ryan 60 or just Ryan. I need to combine those values to come up with the final list of unique builders that just says Ryan. I'm not sure if I can strip off anything from the end as some are Ryan - Greenbrier. I thought maybe removing everything to the right of a blank space, but those entries have 2 blanks. Any help would be greatly appreciated! Thanks! Tag: Phantom spaces after decimal point. Tag: 63980
  - 13
    - little help, i'm sure it's an easy answer ok, i am trying to setup a condition in my excel. i am trying to set i up so that when the value in H2 is less than or equal to 600, the valu in H3 is less than or equal to 15, and the value in H4 is less than o equal to 6 that H7 displays MET. whenever H2, H3, or H4 is above sai values, i would like it to display NOT MET. how would i go about doin so -- Punk0Ram ----------------------------------------------------------------------- Punk0Rama's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2451 View this thread: http://www.excelforum.com/showthread.php?threadid=38110 Tag: Phantom spaces after decimal point. Tag: 63979
  - 14
    - Formula Indictor??? Excel 2003 I have several cells that contain IF formulas in them. If it makes any difference they are formatted to show nothing if a referenced cell is blank i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells, they have a small indicator in the upper left (similar to the indictor to shows that a cell contains a note). I do not want this visible (whatever it is). Why is it there? How do I get rid of it? -- Thanks in advance... Bob Tag: Phantom spaces after decimal point. Tag: 63975
  - 15
    - Validation rule but only sometimes Hi! Thanks to help here, I now know how to set a cell to allow the user to select items from a list elsewhere in a spreadsheet. Data->Validation->List works great! But now I'd like to expand that. I want to make that cell be a dropdown list SOMETIMES, but other times force a specific value (or nothing) into it, all based on the value of another cell. If I put in a validation rule, there's no provision for doing an "if(x,y,z)" where either y or z makes a dropdown list while the other one does not. How can I do this? Mike Tag: Phantom spaces after decimal point. Tag: 63955
  - 16
    - Hiding the "#N/A" value How does one hide this value so that it isn't visible in a cell. Also; it appears that when I try a simple calculation of cells; and one of those cells has this value listed in it; my calculation does not complete. How can I correct this? Tag: Phantom spaces after decimal point. Tag: 63953
  - 17
    - VBA find in string I'm trying to determine what type of park the different National Parks are using the following function. obvisously i'm doing something wrong. in the formula bar i entered =CalcValue(c2) but it returns #value. Module1-> Function CalcValue(MyCell as String) As String If InStr(0, MyCell, "National Park") Then CalcValue = "NP" ElseIf InStr(0, MyCell, "Historic") Then CalcValue = "HP" ElseIf InStr(0, MyCell, "Military") Then CalcValue = "MP" ElseIf InStr(0, MyCell, "Preserve") Then CalcValue = "NPRE" ElseIf InStr(0, MyCell, "Monument") Then CalcValue = "NM" ElseIf InStr(0, MyCell, "Memorial") Then CalcValue = "NM" ElseIf InStr(0, MyCell, "Senic") Then CalcValue = "NS" ElseIf InStr(0, MyCell, "Recreation") Then CalcValue = "NR" Else CalcValue = "0" End If End Function Tag: Phantom spaces after decimal point. Tag: 63951
  - 18
    - Workbook Shared - Excel program bombs out In one Excel 2000 file, which is a workbook shared, we occasionally get a Excel.exe Application error message - Instruction at 0x302b8dbf referenced memory at 0x00000030. The memory could not be read. Once we press OK the Excel program bombs out. Actually file size is 1.5 MB, RAM is 128 MB, P3 -- Carlos Iraburo Tag: Phantom spaces after decimal point. Tag: 63948
  - 19
    - Backups default How can I configure Excel so that when it opens to a new file (Book 1.xls) that the new file I create from there, and save, is defaulted to 'Always Create Backups' and that a backup is automatically created of this new file and of course subsequently created as I edit and save this file. There is probably a default file of Book 1.xls somewhere that controls this? Ron Tag: Phantom spaces after decimal point. Tag: 63943
  - 20
    - Reference Row across Worksheets Hello, I am trying to reference a row from one worksheet to another. Everthing I have tried only display's the first column of the row. It does not have to be the complete row it can be just a group of cells in a row. Any help would be greatly apprecaited. Thanks dblwizard Tag: Phantom spaces after decimal point. Tag: 63942
  - 21
    - remove "type question for help" in SBE Hi, Anyone know how to remove the thing that says "type question for help" in Excel SBE? Thanks Tag: Phantom spaces after decimal point. Tag: 63937
  - 22
    - XML without formatting Excel 2000 provides a nice way to edit XML. However, the problem is that is adds all of this Microsoft formatting stuff (kind of like it does with html). I can open an XML document in Excel make no changes and save it, and the resulting file will be unreadable by the application it came from. I've tried this with 2 different apps. Is there any way to save an XML document in Excel without all of the Microsoft formatting? Tag: Phantom spaces after decimal point. Tag: 63931
  - 23
    - Summing up data from various worksheets I have daily data all on different worksheets (31 in total) and I would like to add up all of the data in these worksheets in a monthly compilation I have so far been using the =sum('jan. 1'!B6, 'jan. 2'!B6 ... etc.) which although is effective is very time consuming is there an easier way to sum up all of the b6 cells without entering them individually? Thanks -- mark_vi_ ------------------------------------------------------------------------ mark_vi_'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24507 View this thread: http://www.excelforum.com/showthread.php?threadid=381001 Tag: Phantom spaces after decimal point. Tag: 63927
  - 24
    - Help w/auto fill or copying I receive a downloaded report and can't change the format in which I receive the report. Therefore, I have to try and get these 20,000+ lines in a format I can use easily. This is the format of the data: Column A Column B Column C, etc.... Name 1____1001_______X _____________________X _____________________S _____________________Y Name 2____1002_______X Name 3____1003_______Y _____________________Y ____________________________________ Each name can have multiple rows of data and there are about 15 columns. I need the information for each row and my first thought was to try and do a pivot table with each column and then just copy/paste values, but because the name/number isn't listed in every row, I just get a lot of blank rows. Does anyone know of any way to fill the blank rows below the Name with the same value as above, without me having to go through all 20,000 lines of data? I have also been wracking my brain of a way to import this into Access to do the same thing with no luck. Thanks! Melane -- melanemac ------------------------------------------------------------------------ melanemac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17255 View this thread: http://www.excelforum.com/showthread.php?threadid=380980 Tag: Phantom spaces after decimal point. Tag: 63923
  - 25
    - Protecting Worksheet Cells I am creating a form in Excel and protecting the cells I don't want users to be able to edit. This also allows me to hit the tab or enter keys to jump to the next available cell. I am able to hit "tab" so it jumps to each available cell from left to right, but at the end of the first row, it jumps to columns on the right of the form which have no data in them and will go on infinitely. So, I have to hit "enter" at the end of each row to move down, then "home" to go the far left side of the form. Is there a way to direct the "tab" key to wrap to the next row, first available cell? Or is there another solution? Thanks! Tag: Phantom spaces after decimal point. Tag: 63922

Hi folks,

Excel 97's gone funny and it is now adding 2 spaces automatically afte
a decimal point on existing and new spreadsheets as they are typed.
don't know what's caused it, can somebody please help. Cheers

--
sutat
-----------------------------------------------------------------------
sutats's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=38154

Top

Re: Phantom spaces after decimal point. by Dave

Dave
Thu Jun 23 07:50:02 CDT 2005

I'd check tools|Autocorrect options first. See if someone is correcting the dot
with dot-space-space.

sutats wrote:
>
> Hi folks,
>
> Excel 97's gone funny and it is now adding 2 spaces automatically after
> a decimal point on existing and new spreadsheets as they are typed. I
> don't know what's caused it, can somebody please help. Cheers!
>
> --
> sutats
> ------------------------------------------------------------------------
> sutats's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24565
> View this thread: http://www.excelforum.com/showthread.php?threadid=381544

--

Dave Peterson

Top

Re: Phantom spaces after decimal point. by sutats

sutats
Thu Jun 23 12:12:33 CDT 2005

Hi Dave, thanks. Your answer was spot on. Thank you

--
sutat
-----------------------------------------------------------------------
sutats's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=38154

Top