Problemas con el reconocimiento de un formato personalizado en celda
Hola buen día, El escenario es el siguiente: previa migración a Office 365, teníamos un archivo excel con varias consultas conectadas a una BD Oracle. Cada consulta descarga los datos en tablas de hoja excel con formatos ya predefinidos, por ejemplo, para un campo de tipo fecha, hemos formateado la columna con un campo personalizado de tipo: ''dd/mm/aaaa h:mm". Pasa que previo a la migración de la suite de Office, nuestros datos tomaban el formato correcto una vez se completaba la carga de datos sobre la tabla. Ahora el formato se pierde -toma el formato General- y el campo de la fecha lo vemos númerico, por ejemplo: Hemos intentado modificar el formato personalizado de la celda, por ejemplo a ''dd/mm/aaaa h:mm:ss" o ''dd/mm/aaaa hh:mm:ss" sin ser esto exitoso. Agradezco de antemano cualquier sugerencia. Saludos.Excel formatting cells missing
Hi, After migrating to suite Office365, we have faced some issues with the custom format applied for some cells in our excel files. I´ll try to explain it next: We have a table with all my columns formatted, is like a template for us, the column/cells with the problem has a custom format like 'dd/mm/aaaa h:mm': *Personalizada = Customized/Custom This table is supposed to be fill it with some data extracted from our Oracle DB. Once we import data using powerquery and loaded it to the table we miss the format: We used to use this "template" before to update the Office suite to "Office 365" and we had no problem, the custom format was maintained. We was wondering if it could be related to the new version of Excel and if exists some solution to be applied... Thanks in advance.
Excel problems with cell format
Hello everyone, My company have a client who works in a excel file and have very big issues that humanity cannot live without a solution. In that file on a random cell without any rule or manual formation i fill it with numbers and change text color, font size 12 bold Arial. So until here everything ok but if i change color and add some letters to that cell, excel auto format my cell to Arial, 10 normal and text color black. i tryed many sollutions without any success. Someone know the solution? Add some photos to see what i ask.Filter Detail
If I have 2 columns. In column 2, a value may repeat multiple times, ex. "1234" is found 5 or 6 times, doesn't matter. I want to know if column 1 has value "ABCD" and "EFGH" on the same rows as "1234" exists in column 2. A more accurate example would be column 2 has Producer A. I want to know if Producer A has, in column 1, "Cars" and on a different line "Trucks". Things to note" - The table cannot be rearranged. - The table is always changing in length, sometimes 5 rows, sometimes 1000 - I would settle with highlighted rows, auto filter, etc. Please forgive if I'm not clear enough.
