String Value not numberValue

L

Legolas_Bilbao

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
 
M

Max

Legolas_Bilbao said:
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??
Click to expand...

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.
 
Top