| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value or Text
Hi all,
object range has value and text property, which is different between them? Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Value or Text
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 "clara" wrote: Hi all, object range has value and text property, which is different between them? Clara -- thank you so much for your help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Value or Text
oops i should say the value = 1.4999999
"Mike H" wrote: 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 "clara" wrote: Hi all, object range has value and text property, which is different between them? Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Hybrid Mode
