View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mary Mary is offline
external usenet poster
 
Posts: 190
Default 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