| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple input/display question
On Sun, 9 Mar 2008 20:46:48 -0400, "Rick Rothstein \(MVP -
VB\)" wrote: To you, 1/1000000000000 is a number; but unlike 1000000000000, which is a number, 1/1000000000000 is text (because the slash is not a number). In order to get Excel to generate a number for the text 1/1000000000000, you have to tell it to perform the division operation... you do that by putting an equal sign in front of it (telling Excel to evaluate the expression. =1/1000000000000 will generate the value you want. Rick Aaaagh. You're right. Thanks guys. My own blind spot of the day -( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Cell display after input | Excel Discussion (Misc queries) | |||
| Simple Question, display only part of a date in Number format | Excel Worksheet Functions | |||
| Simple Date Display Question | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Threaded Mode
