naotosx
(Naoto)
October 29, 2018, 12:16pm
1
Hi i have a little problem i download a .csv file from a web page so after this i save it as .xslx but the numer fields has some errors
“The number of the cell has text format or is preceded by an apostrophe”
But my .csv it’s ok
the problem it’s after i converted to .xlsx
how can i solved this ? some idead please
This is my excel: excel.xls (366.9 KB)
indra
(Indra)
October 29, 2018, 12:21pm
2
@naotosx You can convert text to number by using vbscript
1 Like
naotosx
(Naoto)
October 29, 2018, 12:28pm
3
wich type should i use? if i need to conver text to decimal type with two decimals ?
kaderms
(Kader)
October 29, 2018, 12:43pm
4
Is your xlsx file stored for results?
If yes, then you might have to change the excel cell format to number and then replace the value without the apostrophe (and without the comma too if possible)
If you are not storing that for your results, and maybe using this to read some inputs, then there is no harm in having that apostrophe before your number in the excel cell. Your read range method would just read the number ignoring the apostrophe.
indra
(Indra)
October 29, 2018, 12:47pm
5
@naotosx Is it possible to attach excel file?
naotosx
(Naoto)
October 29, 2018, 12:50pm
6
Sure!, check my post again
@naotosx
Can you please attach original file I mean csv.
Regards,
Karthik Byggari
@naotosx
Follow these steps:
Select the column and change the type to “Text”
Select the column and replace the “,” with “.”
Select the column and change the type to “Number”
And convert the decimal to “,” in the Excel settings as shown in the below link -
Regards,
Karthik Byggari