| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display cell value
can anyone help me out with the option to set the cell value as below
EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula bar to display as 450.00 only |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display cell value
Begin the value with an apostrophe (single quote)
-- Gary''s Student - gsnu201001 "User" wrote: can anyone help me out with the option to set the cell value as below EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula bar to display as 450.00 only |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display cell value
apart from that is there any other way
"Gary''s Student" wrote: Begin the value with an apostrophe (single quote) -- Gary''s Student - gsnu201001 "User" wrote: can anyone help me out with the option to set the cell value as below EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula bar to display as 450.00 only |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display cell value
The Formula bar plays a roll as far as the WS user is concerned and it has no
affect on the cell formats. Can you give us ONE(!) good reason for the need to display, in the formula bar, 450.00 instead of 450 ? Micky "User" wrote: apart from that is there any other way "Gary''s Student" wrote: Begin the value with an apostrophe (single quote) -- Gary''s Student - gsnu201001 "User" wrote: can anyone help me out with the option to set the cell value as below EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula bar to display as 450.00 only |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display cell value
sorry ill not be able to give you the answer for the purpose of it but my
manager wants it so thats it please give me a solution this was available in MS Office 2003 but not in 2007. pls suggest me .... "מיכאל (מיקי) אבידן" wrote: The Formula bar plays a roll as far as the WS user is concerned and it has no affect on the cell formats. Can you give us ONE(!) good reason for the need to display, in the formula bar, 450.00 instead of 450 ? Micky "User" wrote: apart from that is there any other way "Gary''s Student" wrote: Begin the value with an apostrophe (single quote) -- Gary''s Student - gsnu201001 "User" wrote: can anyone help me out with the option to set the cell value as below EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula bar to display as 450.00 only |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display cell value
No, it wasn't. In this respect, 2003 behaved the same as 2007.
If it is stored as a number, it will appear as 450 in the formula bar. If your manager wants to see it as 450.00 in the formula bar then it has to be entered as text (for example by being preceded by an apostrophe), as you were told earlier. -- David Biddulph "User" wrote: sorry ill not be able to give you the answer for the purpose of it but my manager wants it so thats it please give me a solution this was available in MS Office 2003 but not in 2007. pls suggest me .... "מיכאל (מיקי) אבידן" wrote: The Formula bar plays a roll as far as the WS user is concerned and it has no affect on the cell formats. Can you give us ONE(!) good reason for the need to display, in the formula bar, 450.00 instead of 450 ? Micky "User" wrote: apart from that is there any other way "Gary''s Student" wrote: Begin the value with an apostrophe (single quote) -- Gary''s Student - gsnu201001 "User" wrote: can anyone help me out with the option to set the cell value as below EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula bar to display as 450.00 only |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display contents of cell if adjacent cell equals | Excel Worksheet Functions | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
Linear Mode
