Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NumFormat problems when exchanging dot to comma
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as comma csv problems | New Users to Excel | |||
Finding Problems in Comma Separated List | Excel Worksheet Functions | |||
Exchanging information | Excel Worksheet Functions | |||
exchanging X and Y in a plot | Excel Programming | |||
Problems converted comma seperated CVS file! | Excel Programming |