L
Lena_Office
I get a file from SAP where the numbers are strangly formatted. Decimal is
dot and in some cells there is also blank space before (xxx0.0 or x254.45)x
means space.
What I need to do is first to change dot to comma since it is standard in
Sweden, then format the cells with commaseparator and 2 decimals.
This is no problem when I do it manually.
When I use Record Macro, it also works when recording, but not when I test
the code.
The result is that all cells are formatted as text and the smarttag gives
information that the cell is either formatted as text or is proceeded with an
apostrof.
Manually I can convert to number but not through code.
I have also tryed to use the funktion TRIM to remove all blanks and to
replace blanks with "nothing". I have tryed Data, text to column without
success.
Everyting I do works manually but not after recording.
Please can anybody help me!?
Lena
dot and in some cells there is also blank space before (xxx0.0 or x254.45)x
means space.
What I need to do is first to change dot to comma since it is standard in
Sweden, then format the cells with commaseparator and 2 decimals.
This is no problem when I do it manually.
When I use Record Macro, it also works when recording, but not when I test
the code.
The result is that all cells are formatted as text and the smarttag gives
information that the cell is either formatted as text or is proceeded with an
apostrof.
Manually I can convert to number but not through code.
I have also tryed to use the funktion TRIM to remove all blanks and to
replace blanks with "nothing". I have tryed Data, text to column without
success.
Everyting I do works manually but not after recording.
Please can anybody help me!?
Lena