Prev: Hidden cells
Next: Is it possible to use the mouse wheel to scroll horizontally?
From: User on 9 Mar 2010 05:38
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
From: Gary''s Student on 9 Mar 2010 05:42
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
From: User on 9 Mar 2010 05:51
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
From: מיכאל (מיקי) אבידן on 9 Mar 2010 06:25
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
From: User on 9 Mar 2010 06:59
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
 |  Next  |  Last
Pages: 1 2
Prev: Hidden cells
Next: Is it possible to use the mouse wheel to scroll horizontally?