function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lakshmi SLakshmi S 

Excel convert to csv format phone number issue?

Hi Team,

I am converting phone number from excel to csv the format is changing, how can we resolve this?

+91-9900453436 this number changed to like this -9900453345.

please any one let me know , how can i resolve this?


Thanks.
Lakshmi
Ajay K DubediAjay K Dubedi

Hi Lakshmi,
 

I have gone through your problem and for that, you have to do some simple steps:

1) Select the Column where you have inserted the Phone number record.
2) Right, Click on the Column and Format Cells as a TEXT.



         User-added image

If this helps make it the best answer.

Thanks. 

 
Lakshmi SLakshmi S
Hi Ajay,

After changing the cell format as text and converted to csv file, i got same issue.
+91-9900453436 this number changed to like this -9900453345.

Thanks.
Lakshmi.
Ajay K DubediAjay K Dubedi

Hi Lakshmi,

Here is the link to Demo video for the format as text and converted to CSV file.

https://monosnap.com/file/UMVVlxlHF3J7bk9YCqrDZclLnQOnXU

If this will help you mark this as best Answer.

Thanks,
Ajay Dubedi.
Lakshmi SLakshmi S
Hi Ajay,

Link is not working.


Thanks.
Lakshmi.
Ajay K DubediAjay K Dubedi

Hi Lakshmi,
 

Here is the new Link to the Video, Hope this will helps you and can you please tell me the Video link is not working or the solution in a video is not helps you. If this will not help you we can Jump a call and i'll help you.

https://youtu.be/FKpCg0aDJMY

Please let me know if you have any query.

Thanks.