View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---