Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting text to number
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_ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a text word or text string to a number | Excel Discussion (Misc queries) | |||
converting a number to a text | Excel Discussion (Misc queries) | |||
converting a number into text | Excel Worksheet Functions | |||
Converting number to text | Excel Discussion (Misc queries) | |||
Converting text to a number | Excel Worksheet Functions |