G Guest Jun 26, 2007 #1 Hi all, object range has value and text property, which is different between them? Clara
G Guest Jun 26, 2007 #2 Hi Clara, The 'text' value is what is displayed in the cell whereas the 'value' is the value behind what is displayed. as an example put the number 1.4999999 in a cell with the cell formatted to 2 decomal places. the value = 1.49 the text = is 1.5 Mike Mike
Hi Clara, The 'text' value is what is displayed in the cell whereas the 'value' is the value behind what is displayed. as an example put the number 1.4999999 in a cell with the cell formatted to 2 decomal places. the value = 1.49 the text = is 1.5 Mike Mike
G Guest Jun 26, 2007 #3 oops i should say the value = 1.4999999 Mike H said: Hi Clara, The 'text' value is what is displayed in the cell whereas the 'value' is the value behind what is displayed. as an example put the number 1.4999999 in a cell with the cell formatted to 2 decomal places. the value = 1.49 the text = is 1.5 Mike Mike Click to expand...
oops i should say the value = 1.4999999 Mike H said: Hi Clara, The 'text' value is what is displayed in the cell whereas the 'value' is the value behind what is displayed. as an example put the number 1.4999999 in a cell with the cell formatted to 2 decomal places. the value = 1.49 the text = is 1.5 Mike Mike Click to expand...
