Forum Widgets
Latest Discussions
"Reverse FV" function? Or?
Hi all, I need some help please. I would like formula for excel, where I have known inputs: A1 = 30 (number of years) A2 = 500000 (needed capital) A3 = 8% (known yearly return of investment p.a.) A4 = 10000 (initial investment) and I need to calculate needed monthly investment, to reach that required sum (in A2). Thank you very much for your help and time. Daniel
Excel no longer opening files with [] in the file name
Since office 365 upgraded to version 2504 our users have been unable to open files with [ ] in the file name. Example a file with the name [12004][]_MCH_12004-SSC Pacific.xlsx excel throws the errors Basically cutting off the whole file and only finding 12004 now. Why was this functionality taken away. We understand that [] is not recommended in an excel file name. We have antiquated systems written in COBAL that auto generate these file with the brackets. Older versions of office still can access the files but anyone with 365 can not. How can we get this functionality back? Nothing in the changelogs for office version 2504 mentions a change to remove this functionality.
Stop Autofill from Incrementing Certain Cells
I am going to try to explain this the best I can. Please, be patient with me. It might take a few attempts when it comes to properly describing things. Thanks! I am making a spreadsheet that keeps track of the ages for characters in a series I am writing. There are MANY characters, each one with a different birthday. Each story takes place for a different date and year. Right now, there are about 40 periods of time, and those are at the top of the spreadsheet. So, I basically have a character name, their date of birth, and then the subsequent cells calculate how old the character is for that period. When I try to use the auto fill, it increments the cell so that it no longer uses the correct cell. In essence, it tries to use the cell next to the date of birth cell. It does the same thing when I try with the column as well. So, how do I get the autofill to use a static cell horizontally while incrementing the cell vertically? Or the other way around?Macro for overdue expense card reports
Hi. I am trying to figure out a macro that will allow me to use data provided to create a system that allows me to see people who are late submitting their expense card reports. I would like to break it down so that I can see those who are 30, 60, and 90 days past due on submitting their reports. If there is anyone out there that can help me to automate this system rather than manually entering it I would greatly appreciate it. Thank you and have a nice day.
Excel
Português (BR): Estou enfrentando um problema persistente na padronização de dimensões de ilustrações, imagens e pictogramas no Excel. Mesmo ao tentar definir uma altura padrão (ex: '1.4' cm para uma ilustração de hexágono) no campo 'Altura' da guia 'Formato da Forma', duas figuras diferentes, com ambas selecionadas (Segurando Ctrl), resultam com tamanhos divergentes (ex: 1,38 cm e 1,36 cm), em vez do valor exato digitado (1,4 cm). Já verifiquei as propriedades, incluindo a fixação da taxa de proporção, e tentei soluções como copiar/colar e reiniciar o Excel, sem sucesso. O mais intrigante é que, por um breve período, consegui padronizar as dimensões corretamente, mas o problema retornou inexplicavelmente, mesmo no mesmo arquivo. Suspeito de alguma configuração ou atalho que possa estar interferindo. Percebi que isso não acontece, por exemplo, no PowerPoint, apenas no excel. Gostaria de saber se possuí algum tipo de configuração específica para não ocorrer esse ajuste/arredondamento automático no Excel. E gostaria de uma solução eficaz para garantir que todas as ilustrações selecionadas mantenham o tamanho exato que digito.
