• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell changes from text to number

GN0001

Member
Hello team,
I am working on a spreadsheet.
The cells values are text, as soon as I copy the cell, it changes to number and drops the leading zeros. I have to change the cell again to text by going to format dialog box and I have to do it several times, until I get the values saved as a text in the cell.

What is the best approach to take care of this issue?

Regards,
GN0001.
 
Back
Top