Problem is, the .23 is calculated by a formula
so I don't want to replace it with a value

You can try adding a zero to the result from that formula, which would
coerce the text number to a real number w/o impacting on its numerical value.

Easiest for you to try this via a helper col. If the EFT calcs are in C2
down, then just place in D2: =C2+0, copy down all the way. Put a col label in
D1: EFT1 (say), then swap EFT for EFT1 in your pivot's layout.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---