| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a # w/decimal places to no decimals, 13 char's, w/leading 0
To import data into SAP from Excel, I need to create a load file that
converts a column w/positive or negative values & decimal places into all positive values with no decimal places, and with leading zeroes--to fill out 13 places. For example: -74737.76069 needs to be converted to 0000747376069 and 105286.99 needs to be converted to 0000010528699 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal places and leading zeros | Excel Discussion (Misc queries) | |||
| How to change complex 0.122345687+0.87659454j to 3 decimal places | Excel Discussion (Misc queries) | |||
| how do I change default decimal places? | Excel Discussion (Misc queries) | |||
| How to change decimal places in balance sheet template | Excel Worksheet Functions | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
