Bendo
06-03-2010, 09:25 PM
Hi all,
Ok I give up on trying to do this so I humbly ask for some help!
I'm trying to get the visible formatted text from a cell.
So for example in cell A1 I have 4.3 and I have the column formatted for two decimal places. So the cell shows up as 4.30 and this is what I want.
I have a very long formula and when it picks up the cell to paste into a web page, the line gets 4.3 rather than 4.30
How do I grab the visible on screen value of the cell rather than the behind the scenes value?
Thanks in advance
Ok I give up on trying to do this so I humbly ask for some help!
I'm trying to get the visible formatted text from a cell.
So for example in cell A1 I have 4.3 and I have the column formatted for two decimal places. So the cell shows up as 4.30 and this is what I want.
I have a very long formula and when it picks up the cell to paste into a web page, the line gets 4.3 rather than 4.30
How do I grab the visible on screen value of the cell rather than the behind the scenes value?
Thanks in advance