Question:- Some numbers that are formatted as text is this a Bug from MS excel RRS feed

  • Question

  • Hello All,

    I have got some data exported in excel sheet however some numbers are formatted as Text.  I know we can do "Convert to number"  or also use Macro's and many other workaround just want to know if this is a Bug from MS.

    Please help with your suggestion. 

    Thanks in advance.

    Thursday, March 24, 2016 3:00 PM

All replies

  • Hi, Sk1133

    >> can I know from where you got the data imported in excel?

    >> can you provide the steps so that we can manage to create a same result like you?

    Because it is more important to know in which format they are exported.



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, March 25, 2016 2:53 AM
  • How can you tell the formatting is text? Are the numbers quoted, like "123"?

    Best regards, George

    Monday, March 28, 2016 11:28 AM