Forum Discussion
Problemas con el reconocimiento de un formato personalizado en celda
Existe una opción en la pestaña datos, "Propiedades".
Abre un formulario con nombre "Propiedades de los datos externos". Marcando también la opción "Mantener orden, filtro y diseño de columna" solventa el problema.
Saludos.
Hello adrian_dsr,
Try the following:
- Select the column that you wish to update the format.
- Under data tab, "Text to Columns"
- "Delimited", Next
- Uncheck all Delimiters, Finish
Hello PReagan , thanks for your reply
About your suggestion, I cant apply it because previously I had no data on my cells, let me explain it:
- I have a table with all my columns formatted, the one with the problem has a custom format like 'dd/mm/aaaa h:mm':
- After we received data from our Oracle DB (we import data using powerquery) and loaded it to the table, we miss the format:
We used 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 ...
Thanks in advance.
Existe una opción en la pestaña datos, "Propiedades".
Abre un formulario con nombre "Propiedades de los datos externos". Marcando también la opción "Mantener orden, filtro y diseño de columna" solventa el problema.
Saludos.
- I have a table with all my columns formatted, the one with the problem has a custom format like 'dd/mm/aaaa h:mm':