converting text to number
OMG, that is the shortest answer to the darn problem and it worked!!!
Thanks so much Debra
On Jan 26, 5:28 pm, Debra Dalgleish wrote:
You can use the N function:
=N(A2)*B2
nxqviet wrote:
Hi all,
I have a spread sheet with a GetPivotData formula, where I also have an
if statement that replace 0 (zeros) to "" empty cells. This replacement
is critical for some formular to work, but it also make the black cells
not usable for any calculation. If I simply multiply one empty cell by
any number, it would show a #Value! error. How do I avoid this?
I tried Text (...,"#"), Value (...), neither work.
Thanks,
V_--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html
|