Custom Number Format

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
    - Forms and Input Data I created a report form on Sheet 1 and a set of input data on subsequen Sheets 2, 3, ... link to the report. The report is to show informatio on either of the data I select. Are there simple steps for me to pick either set of data I want t display on the report? I've thought of a pull-down menu so that if select "1", the report will show data set "1", and so on. Yet I don' know how to do it. I tried the "replace" command by highlighting al the cell in the Report sheet then type "2" in place of "1" to replac the data set then hitting Ctrl-Enter to make the change. However, thi create a problem because of the many similar number "1", "2", etc. have the the cells. I am a programming illiterate guy. Please help. Thanks. :confused -- eureka e ----------------------------------------------------------------------- eureka eu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1568 View this thread: http://www.excelforum.com/showthread.php?threadid=27211 Tag: Custom Number Format Tag: 47862
  - 2
    - automatic capital letters 2 Questions. (1) I would like to set up the row so that ALL LETTERS in that ro would become Capital letter auromatically. (2) In the second row, I would like excel to capitalize the FIRS letter of each word automatically as I type in the cell -- NYBo ----------------------------------------------------------------------- NYBoy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=836 View this thread: http://www.excelforum.com/showthread.php?threadid=27207 Tag: Custom Number Format Tag: 47856
  - 3
    - Use only part of the number Hi guys, I've got a sheet as follows: Machine_Name Today 1St Day Hrs Wrkd Avg Hrs 8061237 9735.8 9735.8 0 0 8066201 4076.4 4049.4 27 1.08 8066314 6082 5833.2 248.8 9.952 8066315 11847.4 11510.7 336.7 13.468 8066537 3630.6 3472.6 158 6.32 8066543 5799.8 5469 330.8 13.232 In my next coloumn to the right, I need to get the values from "Today", but only the first 3 numerals from the right. eg: (manually typed) Machine_Name Today 1St Day Hrs Wrkd Avg Hrs Hrs Left 8061237 9735.8 9735.8 0 0 735.8 8066201 4076.4 4049.4 27 1.08 76.4 8066314 6082 5833.2 248.8 9.952 82 8066315 11847.4 11510.7 336.7 13.468 847.4 8066537 3630.6 3472.6 158 6.32 630.6 How can I achieve the "Hrs Left" Coloumn by using a formula? Thanks alot in advance Rudi Groenewald Tag: Custom Number Format Tag: 47854
  - 4
    - Number Formatting Thank you, now at least it makes sense! :) -- Nan ------------------------------------------------------------------------ Nan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6785 View this thread: http://www.excelforum.com/showthread.php?threadid=272052 Tag: Custom Number Format Tag: 47852
  - 5
    - summerizing formula for weekly lesson plans Hi, This is a request from a primary school headteacher and a good friend of mine. They use an excel sheet that shows the lesson plan for each teacher. Nothing special on it. But lately they needed some summerizing figures on the sheets. For each teacher, there are "names" in the region G10:K19 in its excel sheet. The names includes a part consisting of the "lesson name" itself and a part consisting the "class" that'l take it (For example "ScienceA1"). Thus the "name" data can easily be seperated because the "lesson name" is at the beginning and the "class" name always starts with a capital letter somewhere in the middle of the text. Now I wanna summerize this data for each teacher down somewhere on the sheet as follow: I want to list these lessons in the region from F24:I24 downwards such that: F24,F25,F26,...etc will be 1, 2, 3, ...etc the number of times a unique name is found in the region G10:K19. G24, G25, G26, ....etc will be each found different lesson name. H24, H25, H26, ...etc will be the involved class for that lesson (e.g A1, B2 etc). I24, I25, I26, ...etc will be the total count of each unique lesson in the region G10:K19. Can you suggest formulas or a macro to do it? Thanks in advance J_J Tag: Custom Number Format Tag: 47849
  - 6
    - row picking I have a large matrix if data made up of blocks of 8 rows of number across 12 columns with a blank row between each set There are 51 blocks of data, out of which I need to group each row fro each set together. e.g, i need to pick row 1 from each of the 51 set and put them together, row 2's all together, row 3 etc, down all rows. Is it possible for Excel to sort the data in this way, or mark each o these rows somehow to refer to them by cells? Thanks for your help. :confused -- Micronau ----------------------------------------------------------------------- Micronaut's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1567 View this thread: http://www.excelforum.com/showthread.php?threadid=27205 Tag: Custom Number Format Tag: 47848
  - 7
    - Number Formatting I want all the cells in my worksheet to have the accounting format wit any $0 dollar entries to appear as a "-". Some of the cells have a "0 or "(0)" instead. I have copied the proper formats to all cells bu can't seem to get them all to look the same. I'm not sure why this i happening. Any ideas? -- Na ----------------------------------------------------------------------- Nan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=678 View this thread: http://www.excelforum.com/showthread.php?threadid=27205 Tag: Custom Number Format Tag: 47845
  - 8
    - MsgBox Hi, How can you insert a enter in your MsgBox? Fe. --------------------------------------------------------------------------- MsgBox prompt:="Please note, there a no files in this directory." "Please log off know, and restart the application." _ , Title:="OOCL Extractor, release version 5.1", Buttons:=vbOKOnly + vbExclamation --------------------------------------------------------------------------- This wil not work, so what is the solution for this? Thanks as always, Mischa Tag: Custom Number Format Tag: 47844
  - 9
    - Print Title Columns This is a stupid thing that I'm pretty sure has no easy answer other than to hope MS adds it for 2005, but I guess it's worth seeing if anyone has a solution. I have a spreadsheet that has column A set as Print Titles and several columns that print on 2 pages with column A repeated as expected. At the bottom of the page, I have some foot notes that are on the page in column A, but they are wider than the column, therefore on page 2, the labels cut off. Most users will be looking at the file on screen, so I don't really want to put the notes in the print footnotes. I've been thinking about an On Print macro that copies the cells to the footnotes, but thought I would check here for an easier answer. kcc Tag: Custom Number Format Tag: 47831
  - 10
    - solver I am running Excel 2002 on an XP computer with lots of ram and hard disk space. I can invoke and successfully run Solver once on a worksheet. When I try and rerun Solver to change constraints etc the computer ignores the request. If I save the worksheet and start over it will remember the previous solver and allow me to edit it. Any suggestions on how to rerun solver without having to close out of Excel and start over? Fred Tag: Custom Number Format Tag: 47830
  - 11
    - ATTN:Paul B - Re: Change cell fill colour on mouse click Hi Paul Thanks for your reply - it seems to be what I'm looking for. However I'm no expert with Excel. Could you please tell me how I go about getting the coding you sent into the VB editor as I've never had cause to use this before. Thanks for your help - it's much appreciated. Cheers Paul Bardsley J Tag: Custom Number Format Tag: 47829
  - 12
    - Not allow entering repeated references in a column - HOW? I have a table to register incoming documents. Its references ar introduced in a column. Each document must have a unique reference (e.g H04, H05, B01, B02 etc.). Hence, repeated references must not occur. What should I do to make sure that repeated references are no introduced in the column... or alternatively, what should I do to mak the system alert the user when he/she is introducing an existen reference? I look forward to receiving your help. Thanks in advance, Ritinh -- ritinh ----------------------------------------------------------------------- ritinha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1566 View this thread: http://www.excelforum.com/showthread.php?threadid=27195 Tag: Custom Number Format Tag: 47826
  - 13
    - Append text to each cell Is there a way to append text to the beginning of and end of a group of cells that have different text entries in them. I want to paste a standard statement at the beginning of each cell without modifying the existing text. I also want to do the same at the end of each cell? Tag: Custom Number Format Tag: 47820
  - 14
    - rounding how can you make excel CORRECTLY round off numbers? For example, I'm multiplying currencies by a percentage, but it keeps giving me a number off by $.01 from when I add up the numbers manually. Tag: Custom Number Format Tag: 47815
  - 15
    - how auto enable macro ? Hi, When my excel macro starts, it asks to user to tell if he enables macro or not. How can i do if i don't want user to answer to this question, but auto enable macro without any user help ? thx, Maileen Tag: Custom Number Format Tag: 47814
  - 16
    - Formatting Question Is it possible to format only part of a cell to be bold? I have a cell that I want to say: Week Start: 09-19-2004 and I have the cell set up to display "Week Start: " through the cell properties, but I want that to be bold. Any ideas? Tag: Custom Number Format Tag: 47812
  - 17
    - Excel Autofiltering Greetings all, Just a quick question about something that has been getting on my nerves with Excel lately: how come sometimes when you do an autofilter on spreadsheet data it tells you in the bottom left corner how many records match the criteria, and sometimes it just says "Autofilter"? Regards Andi Tag: Custom Number Format Tag: 47808
  - 18
    - probleme to open excel document hi when i open my excel documents, the excel 2003 run but the document don't show in the screen. and when i try to open the document by file - open - choose th document, it's open successefuly i have reinstall office 2003 and it's same. :( please help me -- hamz ----------------------------------------------------------------------- hamza's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1565 View this thread: http://www.excelforum.com/showthread.php?threadid=27189 Tag: Custom Number Format Tag: 47807
  - 19
    - show menu and bars Hi, I have an excel sheet where all bars and excel menu are hidden. How can i make everything back to visible using only Key combinaison ? thanks a lot, Maileen Tag: Custom Number Format Tag: 47805
  - 20
    - Problem about the data refer path. Hi All, I do all the work on the network driver, says L:. For example, I have a excel file on the L driver, named XXX.xls. One field in the file is refer to a field in another file on the L driver in following path: L:\aaa\bbb\ccc.xls. But do not know when i find that this field in XXX.xls refer to a local file : C:\documents and setting\username\application data\microsoft\excel\xlstart\aaa\bbb\ccc.xls. Anybody who knows that problem, could help me. Thanks so much in advance!!!! Thanks a lot. Yue Tag: Custom Number Format Tag: 47798
  - 21
    - Newbie Quest. On Pasting Data Between Two Spreadsheets Hello: Using Excel 97 SR 1 with W98. Pretty new at using spreadsheets, although I'm using a fairly old version. But, it's been doing pretty much what i want. Am stumped with this, however: I have copied 5 rows of contiguous data from one spreadsheet. I'd like to past these 5 lines into a second spreadsheet, betweeen rows of existing data. So, I insereted a blank row in the second spreadsheet where I want these 5 lines to start. I thought it would move all the following rows down to enable these 5 lines to be pastedthere. But it is overwriting the following 4 rows of data in this second spreadsheet, rather than moving them down to make room. Do i havbe to make room for the 5 lines first, by inserting 5 blank lines ? I thought it would do this automatically, as long as I started on a single blank line. What might I be doing wrong ? Thanks, Bob Tag: Custom Number Format Tag: 47781
  - 22
    - #div/0! I am trying to get an average score for each month of the year and I have a spreedsheet where the total is the following formula =AVERAGE(H22:H33) But until each month ot the year is completed it only shows #div/0!. Is there a way to force it to show the average if you only have data in H22 and H23 etc? Jim Tag: Custom Number Format Tag: 47778
  - 23
    - Filtering within a pivot table I have a pivot table that is a ranking based on dollar sales. When I change to a different geography many products with "0" sales will show up in the pivot table. I would like to only see products that have dollar sales greater than "0". Thanks for any suggestions. Chris Tag: Custom Number Format Tag: 47777
  - 24
    - Advanced filter poor performance in Excel 2003 I have an advanced filter executed in VBA that worked great until upgrading to Excel 2003. When I put in criteria the first time, the filtering works fine, but when the criteria row is blanked out so that all rows are unhidden, it takes forever for that to happen. I suspect that every formula on the sheet is being recalculated. Is there a technical explanation for why this problem happens now? Is there a way to work around this without setting the sheet calculation option to manual? Tag: Custom Number Format Tag: 47775
  - 25
    - How to convert time to decimal format automatically... sorry for the late respond cause i'm a little bit busy, well...it's working and its great, but how can i do that from A1 to A200 (it just an example) to convert time to decimal automatically. thanks for fast and great answer! -- alek23 ------------------------------------------------------------------------ alek23's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15553 View this thread: http://www.excelforum.com/showthread.php?threadid=271166 Tag: Custom Number Format Tag: 47770
- Next
  - 1
    - Cell formatting changed I have a workbook with 8 sheets in it... for some unknown reason, 1 of the sheets has lost all the formatting of the cells; i.e., the column that was dates now displays 37883 in the first cell, but the bar at the top shows 9/19/2003. The columns that used to be currency now show only numbers (40.9 instead of $40.90). I'm totaling cells across a row, and instead of the dollar total I'm now seeing =SUM(D4:F4). Have no idea what would have caused this... happened as if by black magic! All the other sheets in the workbook are fine. There are no links in this sheet to any other sheet. AND, I cannot reformat any of the cells. Sheet/workbook is not protected. I found that I could copy the offending worksheet and paste it into a new sheet and the new sheet displays correctly! Anybody experienced this before? Know the reason this happens? Very frustrating! TIA DK Tag: Custom Number Format Tag: 47765
  - 2
    - find problems hello, I want to let excel find in a range of cels a certain tekst and get the number in the cel right from that tekst. The tekst is in the range sometimes more than once. If that is it has to calculate the sum of the numbers in the cells right from the tekst. Greets Ivo Tag: Custom Number Format Tag: 47764
  - 3
    - How to join files??? Dear members, I have sever exel files and I would like to join them (make just on file), do you have any suggestions? or any program which already doe it. All the files have the same format and the same information. Thank -- copelet ----------------------------------------------------------------------- copeleto's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1563 View this thread: http://www.excelforum.com/showthread.php?threadid=27178 Tag: Custom Number Format Tag: 47762
  - 4
    - Links and NA I use excel (excel 97 on a windows 2000 machine) to manage the patient care schedules of 10 physicians -- and having been doing so for years. 2 years ago, I started having problems with the links from the main worksheet (the working document where ALL changes are made) to the final worksheet which is month to month schedule and is the printed document that everyone else sees and uses. What happens is that when I open the month to month worksheet, frequently it will have NA values -- not consistently -- variably. Variably I can fix it through a variety of means (but the fixes are temporary) -- sometimes re-closing the final worksheet and reopening it will resolve the problem, sometimes reopening the main worksheet first, sometimes reopening the main worksheet last, sometimes refilling the final worksheet with the data. This occurs sometimes after changing data and other times after no changes in data -- just desiring to print a schedule (all print jobs are ONLY on the final month to month worksheet). If it matters, the print jobs always reflect what is in the worksheet - so I do NOT get a printed worksheet with NA values but no NA values in the linked on screen worksheet. I have usually linked the last month of the year to the first month of the next year ... because of these problems; I STARTED A BRAND NEW WORKBOOK FOR 2005. Virtually no data is in this new 2005 worksheet EXCEPT for inputed schedules for the last week of 2004 and first week of 2005 --- it is NOT linked to the 2004 schedule. YET -- I get the same variable result when I open the new 2005 final month to month worksheet (which is linked to a second worksheet which is linked to the initial 2005 schedule with a lot of extra columns. now the specifics: a) the main worksheet has 365 rows -- this main worksheet is the ONLY worksheet in which schedule changes are EVER made, all of the other worksheets are there for formatting issues b) each row is for each day of the year c) the first and second column are the dates of the year and the days of the weeks d) the next column is for a manually entered schedule such as 8:30-6, or 8:30-12:30/adm/1:30-5 or some other combination e) the next column 2 columns is a letter of the alphabet f) the next column (sometimes 2-3) contains a number g) each of d-f is repeated for EACH physician (about 3-6 columns per physician) this main worksheet is linked to second worksheet which ONLY contains columns c, d and e (NOT columns f) this second worksheet is then linked to one of 12 worksheets which is a monthly schedule. It is in THIS MONTHY worksheet which is in **a different workbook** and is accessible to everyone in which the NA values turn up. NOTE -- there are NO formulas thoughts?? mark Tag: Custom Number Format Tag: 47758
  - 5
    - numberlist? i want to make a list in excel from 1 to 100, i have read many help file's but i can't get it done. Is here someone here to help out? All the best, Henk. Tag: Custom Number Format Tag: 47755
  - 6
    - xcel Number Formatting Problem Hi there, I have exported accounting information from a company data website int excel. For some reason, where profit figures had a 1000 seperator (, on the website, when exported into excel the 1000 seperator became decimal point (.). Also, the profit figures taken from the website ar in GDP th i.e. excluding the last '000'. Therefore, please can you help me do the following: 1) Replace the unwanted decimal point (.) back to a 1000 seperato (,). 2) Add 000 to the end of the profit figures so that they are in writte in full. Many thanks And -- andyp16 ----------------------------------------------------------------------- andyp161's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1165 View this thread: http://www.excelforum.com/showthread.php?threadid=27176 Tag: Custom Number Format Tag: 47754
  - 7
    - not less that zero what do I do so a will get "0" if the answer is less than zero such as 5 - 6 and it give me "0" Tag: Custom Number Format Tag: 47750
  - 8
    - Weird Coding Hi, this is my first post and I was hoping that someone could help. My friend the other day installed a program that caused him to lose all of his excel files. Fortunately, he was able to do a system restore and was able to retrieve the files that were lost. However, upon opening them the files were filled with these weird script codes. Is there a way to fix the file so that information is displayed correctly in excel when it is opened? Tag: Custom Number Format Tag: 47747
  - 9
    - Change cell fill colour on mouse click Hi in order to record pupil achievement I would like to change the fill colour of any cell in a worksheet by clicking in it once with the mouse. Can anyone tell me how I go about getting Excel to do this please. Cheers PAUL Tag: Custom Number Format Tag: 47743
  - 10
    - How to switch off automatical change data type? Hi, I input "1/4" or something like that, actually, it's a string, but Excel is to smart to change it to Jan 4, 2004. I would like to know how to stop this automatic change? What's the code to do so? As I am actually using VB code to operate Excel. Thank you! Tag: Custom Number Format Tag: 47728
  - 11
    - Removing a bookmark in excel Hi there! I made a book mark in excel. How to do this I could read in the help file. Now I want to remove this bookmark. Í can't do this. In the help file there is no information on removing bookmarks. Does anybody know how to remove a bookmark in excel? Thank you, Werner Hoogeveen Tag: Custom Number Format Tag: 47725
  - 12
    - Opening an Excel 2002 worksheet in Excel 2003 I created a spreadsheet using Excel 2002 (XP). I need to open that spreadsheet using Excel 2003. When I try to open the 2002 spreadsheet in Excel 2003, I can only see a portion of the spreadsheet and cannot scroll. I could copy and paste each sheet from the 2002 spreadsheet to a new 2003 spreadsheet, but I cannot even see the tabs at the bottom. How do I open the 2002 spreadsheet in Excel 2003? I do not see a way to convert from the 2002 format to 2003. Thanks. BT Tag: Custom Number Format Tag: 47722
  - 13
    - Excel not unhighlighting selection I am experiencing an issue with 2 PC's that are having the same issue. When the user goes to select cells, Excel doesn't release the selection box and the user is unable to 'release' the selection box, no matter what they do. Even killing Excel and reopening didn't stop the matter. The users have to restart the PC in order to get it to work and even then, it comes back. This is happening in Excel 2000 & 2003. The keyboard is not on any KVM and does work fine in other applications. Replacing the keyboard didn't help. Any thoughts? Thanks! Tag: Custom Number Format Tag: 47721
  - 14
    - where excel opens a workbook I have some documentation in an excel workbook. Each worksheet contain information. I have several users who can edit the information. Whe they save the file it opens in the condition they had it in when the saved. Is there a way to force all sheets to location A1 and open to certain worksheet each time -- mikegosp ----------------------------------------------------------------------- mikegospo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=338 View this thread: http://www.excelforum.com/showthread.php?threadid=27162 Tag: Custom Number Format Tag: 47718
  - 15
    - Odd character I have a file that has been exported from Outlook to an Excel file. In some of the address fields the Address1 and Address2 lines are separated by some character that does not seem to be recognized by Excel. In the cell it looks like a 'pipe' character that is bold...sometimes 2 of them. In the Formula Bar it appears to be a small box. It also pushes this Address2 to a second line in the formula bar. I need to import this to another program but that program chokes on this character. Can anyone help me to clean this out of the data? Dave French Tag: Custom Number Format Tag: 47717
  - 16
    - HTML tags changing cell shape and size Hi, I am working on some html text in excel spreadsheet. When I past some HTML in a cell, the cell changes shape according to the html tags For example, text will become bold if <b></b> is used and font change in a similar way. Is there are way I can disable html in a cell altogether where exce treats it just like text and shape of my cell doesn't change? Thank -- wmciu ----------------------------------------------------------------------- wmcius's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1561 View this thread: http://www.excelforum.com/showthread.php?threadid=27159 Tag: Custom Number Format Tag: 47715
  - 17
    - Excel and Access Hi guys, I'm trying to link my excel sheet to my ms-access db, but thi is the following error that I'm getting: I have some values on my excel sheet like 2215291051006 2215296060601.. and so on, and I have them formatted as Text, but whe I go to ms-access and I click to link a table or to import the table.. those values are changed to this 2.215296060601E+12, I mean to the dat type is changed to number instead of keeping the data type as Text... anyone knows how can I fix this???? Thanks Jessic -- jessie247 ----------------------------------------------------------------------- jessie2477's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560 View this thread: http://www.excelforum.com/showthread.php?threadid=27156 Tag: Custom Number Format Tag: 47711
  - 18
    - 'Ghost' Link In Workbook Sometimes, when I open a workbook, I get a window telling me that th book has an outside link to another book, though I'm not aware o having linked it. A search for the link turns up nothing, an sometimes - Even if I delete the contents of the entire sheet - Th link still shows up under the 'Edit' menu. It is _extremely frustrating!!! Any feedback on this would be appreciated -- bohnnevill ----------------------------------------------------------------------- bohnneville's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560 View this thread: http://www.excelforum.com/showthread.php?threadid=27156 Tag: Custom Number Format Tag: 47710
  - 19
    - Copying cell contents I am using Excel 2000. I need to copy a name that is located on Sheet 1 cell A5 to a certain cell on Sheet 2. I was hoping to put a formula in my Sheet 2 cell that would automatically place the name there for me, but so far I haven't been able to get anything to work. I don't want to use a macro for this. Can anyone please help? Tag: Custom Number Format Tag: 47703
  - 20
    - Custom Number Format It really won´t work. I keep getting the -Formula With Error - pop-up. It always points to these parts in bold: =left*(b4,1)*&"-"&mid*(b4,4,7)* Am i screwing it up somehow ? -- Excelder ----------------------------------------------------------------------- Excelders's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556 View this thread: http://www.excelforum.com/showthread.php?threadid=27130 Tag: Custom Number Format Tag: 47702
  - 21
    - Sorting Hi All, Currently my Excel 2003 sorts in the following order: 1 2 3 4 1A 1B 2A 2B A B I want to be able to sort in this order: 1 1A 1B 2 2A 2B 3 4 A B I have looked in excel and was unable to find a way to do this. Any suggestion? Tag: Custom Number Format Tag: 47698
  - 22
    - using between 2 numbers in a case select Hello, I was wondering if someone could help, I'm writing a case select wher the first case is <50000, and the next one is between 50000 and 250000 I can't seem to figure out how to do between 2 numbers with a cas select. any help with this would be greatly appreciated Cheers in advance Ri -- rikkin ----------------------------------------------------------------------- rikking's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=970 View this thread: http://www.excelforum.com/showthread.php?threadid=27147 Tag: Custom Number Format Tag: 47694
  - 23
    - Recalculating a custom function I have made a custom dice rolling function for my spreadsheet as below. The problem is that it does not automatically update. Normally, having randomize(1,6) or whatever will recalulate when i press F9, but to make this recalculate, I have to go into the cell and press enter. Is there a way to make this recalculate normally? Function ROLL(count As Integer, die_size As Integer) As Integer Dim i For i = 1 To count Step 1 Randomize ROLL = ROLL + Int((die_size * Rnd(1)) + 1) Next i End Function -- -- Fabian Visit my website often and for long periods! http://www.lajzar.co.uk Tag: Custom Number Format Tag: 47692
  - 24
    - Sorting a column by using formula I am trying to use sort function just to delete blank cells in between Sort order doesn't matter actually. Data is coming by the use of simple cell reference of "another sheet -- Prais ----------------------------------------------------------------------- Praise's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1558 View this thread: http://www.excelforum.com/showthread.php?threadid=27144 Tag: Custom Number Format Tag: 47690
  - 25
    - Count Values in same worksheet - Urgent please Hi, I have a number in cell E14. (Eg36) I need to sum values in the next non blank 36 cells starting from cell Q14. The result from the above should be cell D14. Please help. Thanks in advance. Tag: Custom Number Format Tag: 47682

Hey guys, thank you all for the great help.

Due to my Excel local settings (-Brazilian Portuguese-) i had to wor
out around some changes.

The formula worked *absolutely great * after some changes:

=ESQUERDA(B4;1)&"-"&EXT.TEXTO(B4;4;7)

Thanks A LOT!!
:)

The Excelder

--
Excelder
-----------------------------------------------------------------------
Excelders's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556
View this thread: http://www.excelforum.com/showthread.php?threadid=27130

Top