ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   String Value not numberValue (https://www.excelbanter.com/excel-worksheet-functions/109053-string-value-not-numbervalue.html)

Legolas_Bilbao

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

Max

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

Nobody

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



All times are GMT +1. The time now is 10:13 PM.

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