| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
String Value not numberValue
I´m export data to excel file but if a reference like 0034 appears like 34,
and i want its appears 0034, what must i do?? thanks for all |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
String Value not numberValue
"Legolas_Bilbao" wrote:
I´m export data to excel file but if a reference like 0034 appears like 34, and i want its appears 0034, what must i do?? Pre-format the col as text before you paste as values. Or, if using Data Text to Columns, in step 3 of the wizard, select the col in the data preview pane, then check "Text" under Column data format. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
String Value not numberValue
Format Cells as 0000
--------------- mama no teeth "Legolas_Bilbao" wrote: I´m export data to excel file but if a reference like 0034 appears like 34, and i want its appears 0034, what must i do?? thanks for all |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
| List File Properties - Author | Excel Worksheet Functions | |||
| Browse File for Mac | Excel Discussion (Misc queries) | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
Hybrid Mode
