Full Numbers in CSV

[vikas_newports]

I generated a CSV file from data and the problem is that the numbers are showing as in the picture while when I click on it they are the full number in the formula bar
I want to show ful in cell too . I am doing from VBA so please guide me
How can I do it

 

[fadee2]

I am not sure I get your point. Do you mean after generating the csv you want to change your numbers in the csv file?

 

[vikas_newports]

We can do it before the generation of csv
I am trying to display full number in CSV of Column A as shown in the Macro Salaries sheet

 

[pedro-egoli]

Check out
Microsoft advice on converting text to number
This is what i got from following that and formatting as number with no decimal places

265884588929

 

[vikas_newports]

Check out
Microsoft advice on converting text to number
This is what i got from following that and formatting as number with no decimal places

265884588929

We are trying to do it in VBA

 

[fadee2]

the code works fine. look below

 

[vikas_newports]

when we save this csv and open the again then it shows as scientific numbers or transacted numbers

 

[pedro-egoli]

when we save this csv and open the again then it shows as scientific numbers or transacted numbers

see my post above

 

[fadee2]

I thought this is the default functionality Excel. And this is exactly the case, look at this

 

[vikas_newports]

Thanks Fadee then we need to close this topic

 

[fadee2]

Thanks Fadee then we need to close this topic

Yes, I guess there is not much that can be done.
you're very welcome