Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

​how to avoid warning 'the number in this cell is formatted as text or preceded by an apostrophe ' in excel out put

  • 1.  ​how to avoid warning 'the number in this cell is formatted as text or preceded by an apostrophe ' in excel out put

    Posted Tue June 18, 2019 01:08 PM
    Hi Everyone,

    I have a field with value as  (03596) and when exported into excel its showing warning  'the number in this cell is formatted as text or preceded by an apostrophe '.

    I have tried to change the format of this field to be number  or text but none works.

    Anyone has workaround for this?





    ------------------------------
    ella ye
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: ​how to avoid warning 'the number in this cell is formatted as text or preceded by an apostrophe ' in excel out put

    Posted Wed June 19, 2019 02:32 PM
    When formatting is stripped from cells in Excel, numbers stored as text are easily recognized because they align left.

    To quickly convert the text to numbers, do the following:

    • Enter 1 in any unused cell.

    • Select that cell and copy it.

    • Select the range of cells to be converted to values.

    • Select "Paste Special"... 



    • Select "Values" and "Multiply" from the menu, then "OK"...



    • Any numbers stored as text will be converted to values, which will then align right...



    I hope this helps.

    ------------------------------
    George Helbling
    ------------------------------

    Original Message


  • 3.  RE: ​how to avoid warning 'the number in this cell is formatted as text or preceded by an apostrophe ' in excel out put

    Posted Wed June 26, 2019 11:51 AM
    Hi George,

    Thanks for reply.

    However, the solution that I was looking for is not to format in excel. It's in cognos. A new excel list will be generated and sent to users every time and it needs to be right.

    Ella

    ------------------------------
    ella ye
    ------------------------------

    Original Message