ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   leading zeros NEEDED during imports (https://www.excelbanter.com/excel-programming/384520-leading-zeros-needed-during-imports.html)

Rusty

leading zeros NEEDED during imports
 
I am trying to import numbers from one program to excel. (I do this
routinely) This program imports numbers... LOTS of numbers, to include LOTS
of numbers that preceed themselves with the number "0" (or sometime 2 or
three "0"s...) It is important that these numbers transfer.. I do not have
the time to run through 65,000 numbers and pick and choose which ones are
supposed to have a zero before them or not. Is there a way to change Excels
formatting on "my" pc so whatever I import to it, it will duplicate it
"EXACTLY"?
PLEASE ASSIST

Jean-Yves[_2_]

leading zeros NEEDED during imports
 
HI,

Format your column as text before importing
Regards
JY

"RUSTY" wrote in message
...
I am trying to import numbers from one program to excel. (I do this
routinely) This program imports numbers... LOTS of numbers, to include
LOTS
of numbers that preceed themselves with the number "0" (or sometime 2 or
three "0"s...) It is important that these numbers transfer.. I do not
have
the time to run through 65,000 numbers and pick and choose which ones are
supposed to have a zero before them or not. Is there a way to change
Excels
formatting on "my" pc so whatever I import to it, it will duplicate it
"EXACTLY"?
PLEASE ASSIST





All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com