OK,..this one is killing me!
I have a cell in a worksheet. It contains a formula for dealing with numbers. IT WORKS GREAT!! The formual for dealing with numerical entries is shown below: Again it works.
[<1000000]#,"K";[>=1000000]#,###,,"M";General
I linked that cell to another cell in another worksheet (same workbook)
I linked them by doing this:
Copied Cell 1....(in worksheet1)
Selected "Paste Special" on Cell 2 (in worksheet 2)and selected apply link.
Great, this works! Any data placed in cell 1 is automatically copied into cell2 in worksheet 2.
Problem!
There is a stupid "k" symbol that resides in cell 2 whenever cell 1 is empty.
Cell 1 is nice and blank when it is empty, but again,..Cell 2 has a "k" in it.
I cannot seem to get rid of it no matter what I do!
Oh and the formula is designed to do this just as an FYI:
If the end user types in 100000 the result reads 100K
If they type in 1000000 the result reads 1M.
I have a cell in a worksheet. It contains a formula for dealing with numbers. IT WORKS GREAT!! The formual for dealing with numerical entries is shown below: Again it works.
[<1000000]#,"K";[>=1000000]#,###,,"M";General
I linked that cell to another cell in another worksheet (same workbook)
I linked them by doing this:
Copied Cell 1....(in worksheet1)
Selected "Paste Special" on Cell 2 (in worksheet 2)and selected apply link.
Great, this works! Any data placed in cell 1 is automatically copied into cell2 in worksheet 2.
Problem!
There is a stupid "k" symbol that resides in cell 2 whenever cell 1 is empty.
Cell 1 is nice and blank when it is empty, but again,..Cell 2 has a "k" in it.
I cannot seem to get rid of it no matter what I do!
Oh and the formula is designed to do this just as an FYI:
If the end user types in 100000 the result reads 100K
If they type in 1000000 the result reads 1M.