R
Rune Wentzel Helms
I have a sheet that sums up costs for clients, by adding them through an If
function, so identical clients are added up in a single cell. This coloumn is
formattet as numbers.
When I import the sheet to a pivot table in another sheet, it treats the
numbers as text (I believe). I can see the numbers under the price field, but
in the table it is shown as "0" or "division by 0" depending on the setting
in the value field.
I have tried copy pasting all the data to a sheet in the same file as the
pivot (inserting values) - and this works fine. I have also consulted our
"in-house" specialists, but they have never seen this problem before - also
it worked without problems initialy, but after an update all prices
dissapeared.
I hope someone can help, as it would take quite a long time to recreate the
sheets from scratch.
Sincerely Rune Helms
(I use a danish version of excel, so the terms might be a bit off, as I have
just translated to english. If anything is unclear just ask)
function, so identical clients are added up in a single cell. This coloumn is
formattet as numbers.
When I import the sheet to a pivot table in another sheet, it treats the
numbers as text (I believe). I can see the numbers under the price field, but
in the table it is shown as "0" or "division by 0" depending on the setting
in the value field.
I have tried copy pasting all the data to a sheet in the same file as the
pivot (inserting values) - and this works fine. I have also consulted our
"in-house" specialists, but they have never seen this problem before - also
it worked without problems initialy, but after an update all prices
dissapeared.
I hope someone can help, as it would take quite a long time to recreate the
sheets from scratch.
Sincerely Rune Helms
(I use a danish version of excel, so the terms might be a bit off, as I have
just translated to english. If anything is unclear just ask)