![]() It seems that what you'd like to have is a BESTX format, but since we don't have that, you may have to find some other workarounds. ![]() I can't think of a solution using SAS-supplied formats. Since you said that you were exporting from WRS, your best bet for help might be to contact Tech Support. Produces this output.where you can see that numx without a 'd' is working the same way that the w.d works without a 'd'. It seems to me that everything is working as designed. If d is 0 or you omit d, w.d writes the value without a decimal point. I have recieved a Dutch Excel spreadsheet in Euro format, i.e. Heres a way you can do the steps: Press Ctrl+H to display the Replace tab of the Find and Replace dialog box. In the third one youll then change the 'neutral' character you used in the first find and replace to the commas. I work in Excel UK format decimal numbers, i.e. In the second one youll change the decimal comma to a decimal point. The w.d format rounds to the nearest number that fits in the output field. This question concerns decimal points and decimal commas. I could use the NUMX-format, but then I'll get decimals even for the integer (which stands for 90 of the values). I want to use a format like Best-format, where I exchange dot with comma. The NUMXw.d format is similar to the w.d format except that NUMXw.d writes numeric values with a comma in place of the decimal point.Īnd then, if you look at the doc for the w.d format: It's important when you work with export to excel (swedish version) from WRS. NUMX format is closer to the w.d format - NOT the BEST. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |