Pivot Table (2000)

Topic

New Reply

Hello Out There!

This is a pivot table conundrum. I’m creating a pivot table from another Excel spreadsheet. When attempting to sum cells from the original spreadsheet in the pivot table (under field settings), I see that it will not accomodate if the cells from the original spreadsheet are not in a formula format. Is there a quick way that I can, perhaps, add equals signs to myriad cells already containing numbers? Other suggestions welcomed.

Many thanks!

Reply | Quote

Replies

you can try this:

say the data you need to add an = to is in column M. add a column next to it, or anywhere really, and do a concatenate formula:

=concatenate(“=”,M3)

This should give you =Number in your new column (say =56). Then just copy and paste-value (under Paste Special) back into the original column.

If you need to hide the = and it is showing up in the cell, make sure the column M is formatted as a number. Then you can highlight that column and do a find on = and replace with =. This will then “hide” the = (and you’ll just see 56 in the cell, but see =56 in the formula bar).

A screwy way to do it, but it gets the job done.

Reply | Quote

Many thanks and all the best to you!

Reply | Quote

Many thanks and all the best to you!

Reply | Quote

As feedback, the way I was able to get the pivot table to work was to use the “text to column” function in Excel.

Reply | Quote

As feedback, the way I was able to get the pivot table to work was to use the “text to column” function in Excel.

Reply | Quote

you can try this:

say the data you need to add an = to is in column M. add a column next to it, or anywhere really, and do a concatenate formula:

=concatenate(“=”,M3)

This should give you =Number in your new column (say =56). Then just copy and paste-value (under Paste Special) back into the original column.

If you need to hide the = and it is showing up in the cell, make sure the column M is formatted as a number. Then you can highlight that column and do a find on = and replace with =. This will then “hide” the = (and you’ll just see 56 in the cell, but see =56 in the formula bar).

A screwy way to do it, but it gets the job done.

Reply | Quote