Forum Discussion
Solved
CELL FORMAT CHANGE
I have some problems with excel changing cell format in previous files or files coming from outside. When I try to change from general to value, excel change to customer format and the sum is not p...
- Hi Hans,
PROBLEM SOLVED!!!
I found how to change setting in the imported file ( exploring around some of your previous ideas - i.e. text to column, decimal separator, ... ).
Thank you very much
I set horizontal alignment ...
here is my screenshot
It' s different from yours ...
I can't understand why
Have you some idea?
It might be caused by a difference in system settings.
- Hi Hans,
PROBLEM SOLVED!!!
I found how to change setting in the imported file ( exploring around some of your previous ideas - i.e. text to column, decimal separator, ... ).
Thank you very much I'm afraid I'm out of ideas.
- Hi Hans,
how can I change this setting for imported files? I use point as decimal separator, you use a comma.
Hi Hans,
what kind of system setting could cause,
in imported file,
NO CHANGE in the number of decimal numbers?
See examples:
https://drive.google.com/file/d/1SRmvjaKuDEd81bc_RsrPPeS3JgLl0CnQ/view?usp=share_link : setting 2 decimal numbers leads to 3 decimal numbers as a result
https://drive.google.com/file/d/1QspBBpjWNrV88qT8nFWXmygYjP_6bTxN/view?usp=share_link : setting 6 decimal numbers leads to 3 decimal numbers as a result