Prev: Default date format (with shortcut keys)
Next: Calculate Filtered Columns
From: vinstream on 6 Apr 2010 05:37
Hi,

I have a Pivot table with some numbers in it. Is there a way to
replace the numbers with a text?

For example: replace all numbers >1 with "yes" . Is this possible? If
not whats the best way to achieve this?


Regards,

Vinstream


From: ozgrid.com on 6 Apr 2010 05:48
Only by changing your data source. Eg.

Sub Test()
Dim rCell As Range

For Each rCell In Range("DataSource").Columns _
(2).SpecialCells(xlCellTypeConstants, xlNumbers).Cells
If rCell > 1 Then rCell = "yes"
Next rCell
End Sub


"vinstream" <vinstream(a)gmail.com> wrote in message
news:717e46fc-1fd8-4e5a-b479-efcb68226000(a)z6g2000yqz.googlegroups.com...
> Hi,
>
> I have a Pivot table with some numbers in it. Is there a way to
> replace the numbers with a text?
>
> For example: replace all numbers >1 with "yes" . Is this possible? If
> not whats the best way to achieve this?
>
>
> Regards,
>
> Vinstream
>
>

 | 
Pages: 1
Prev: Default date format (with shortcut keys)
Next: Calculate Filtered Columns