Forum Widgets
Latest Discussions
Le séparateur de milliers ne fonctionne pas dans Excel sur Mac
Dans les anciens fichiers Excel sur Mac, le séparateur de milliers ne fonctionne pas quand le format est "Feuille de calcul open XML strict (.xlsx)" alors qu'il fonctionne très bien avec le format "Classeur Excel (xlsx)". Mais dans "Enregistrer sous..." il n'est pas possible de changer de format. Merci de votre assistance !
Worksheet tabs to include date from a cell
Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.
CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?
IF ISBLANK and NOT
Hi all, I am banging my head against a brick wall trying to figure this out. Column C has a day in it. Cell X6 has a value in it which automatically updates every day. Column X has new values entered every day. The value in column AM for each row is calculated with a formula, so it will give the value of X6 if X in the same row is empty, or 0 if X in the same row has a value. =IF(ISBLANK(X324),X$6,0) will give me what I want if just looking at the cell in row X, but I also need to check if C324 is either Saturday or Sunday. =IF(AND(OR($C327="Saturday",$C327="Sunday"),(ISBLANK(X327))),0,X$6) will give me 0 if X327 is Blank and C327 is either Saturday OR Sunday, but will not give me 0 if X327 is Blank and C327 is not Saturday or Sunday. Is there a way to use the NOT function with the ISBLANK to say if X327 is Blank and C327 is not either Saturday or Sunday then it will return value X6, but is any of those statements are not true then it returns 0. Thanks in advance...
Excel Comments gone/unable to view
I've created a workbook to log information for my work. In this, I had a notes section that I could log all conversations I had when I had contacted a customer so when I hover over the purple indicator in the cell, it would show me the conversations/key notes i've had with customers. I have just opened my workbook today to try and view/add to these comments and all comments now have a red indicator in the cell and the text says the following ' [Threaded Comment] Your version of excel allows you to read this... How can I recover my notes as they are extremely important to my work.Threaded Comments/Notes after update
Got a message that I needed to update this morning, I thought I was already working on most up to date version, but I clicked OK and updated office 365. When I opened up my worksheet I looked at a threaded note/comment (white box with 'Post' button) I had left on a cell last week. It has changed to a comment (the yellow box, I'm loosing track of which is which). It also shows this message on all the comments: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 I no longer see any options for Notes. Not on the Review Tab, shift-F2, or right-click menu. I can only open comments (yellow text box). I would like to see my comments as threaded notes again and start posting more. It looks like the most recent info from "Help" and the support pages is telling me that the threaded comments are the ones I 'post,' and the yellow text boxes are 'notes.' but when I insert a 'comment' it opens up the yellow text box and all the editing options are for 'comments' which refer to the yellow text box. Any help would be appreciated.Cleaning up data with Macros
Hello everyone! I am cleaning up a worksheet that I use frequently to track weekly expenses and spending. I just discovered Macros and I want to use them to clean up my worksheet. Using Macros, how can I create a button that clears entries that are 3 (or more) months old?
Problem creating an Excel formula
I am contacting you because I am having trouble creating a formula to count names in an Excel spreadsheet. I have created a schedule in Excel in which there is usually one name per cell. The calculation of these simple cells is fine. However, in cells where there are two names written ‘NAME F.1 / NAME F.2’, only the first name is counted. I do not know how to make the second name count as well. If necessary, I can send you the Excel file. Thank you for your help, as I do not know how else to solve this problem.
