Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Experts,
I have a situation where I import tabular data from an engineering drawing in which some data may be of the form 012. However, upon typing 012, excel automatically deletes teh number '0'. Is there a workaround this Any information greatly appreciated. Kind Regards Ed |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Type ' then enter the number. It won't show in the cell. Mike "Eddie Morris" wrote: Dear Experts, I have a situation where I import tabular data from an engineering drawing in which some data may be of the form 012. However, upon typing 012, excel automatically deletes teh number '0'. Is there a workaround this Any information greatly appreciated. Kind Regards Ed |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Fri, 7 Nov 2008 01:57:00 -0800, Eddie Morris
wrote: Dear Experts, I have a situation where I import tabular data from an engineering drawing in which some data may be of the form 012. However, upon typing 012, excel automatically deletes teh number '0'. Is there a workaround this Any information greatly appreciated. Kind Regards Ed It depends on how you are importing the data and the nature of the data. If it is a .txt file, the text import wizard will give you the opportunity to specify that column as TEXT prior to the import. If it is a .csv file, you will need to rename the file to <original_name.txt first. If your engineering program is in Excel format, you will have to change that within the external program. If all of the "numbers" have three digits, including the leading "0", you can do some manipulations after importing. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Formating Cells | Excel Worksheet Functions | |||
Custom formating of cells | Excel Worksheet Functions | |||
How to change cases from small to capital in all cells? | Setting up and Configuration of Excel | |||
Why do the cells I am custom formatting save in special, polish | Excel Worksheet Functions | |||
Custom number formats - Selective cases | Excel Discussion (Misc queries) |