number format in excel sheet

Shambhu Rai 1,406 Reputation points
2023-01-19T10:52:23.3133333+00:00

Hi Expert how to change datatype in pivot table in excel sheets . from text to numbers

currently value is in text as it is in column section

i,e.

id value

1 23

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,493 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2023-01-19T11:00:12.0566667+00:00

    Your question is very vague.

    If you mean the number format of a measure, click on the small black arrow => last option => Number format

    1 person found this answer helpful.
  2. Shambhu Rai 1,406 Reputation points
    2023-01-19T13:47:38.6733333+00:00

    error pivot table cannot be updates with differ layout

    1 person found this answer helpful.
    0 comments
  3. Shambhu Rai 1,406 Reputation points
    2023-01-19T18:49:05.8733333+00:00

    suggestion please

    1 person found this answer helpful.
    0 comments
  4. Emily Hua-MSFT 27,546 Reputation points
    2023-01-20T09:32:06.52+00:00

    Hi @Shambhu Rai

    I creates a sample, and as you said put number values in Column Field.

    Capture43

    I suggest you select these cells, right click them > Field Settings > Number format > Choose "Number" format.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  5. Shambhu Rai 1,406 Reputation points
    2023-01-20T10:50:22.9633333+00:00

    Hi Expert,

    i am using ssas cube and option is disables

    User's image

    1 person found this answer helpful.