Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

MS changed this behavior in xl2003 (I think).

Tell her to type 25.0 to get the whole number.

I use xl2003 SP2
and I can type 25. and the value in the cell is 25.
(I'm not sure if the behavior changed back with one of the service packs.)

Carla wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

--

Dave Peterson

Carla,

Methinks your client has poor memory. What you see is what is intended.

You probably need to format the cell as Number, with 2 dec places,
FormatCellsNumber.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Carla" wrote in message
...
Maybe this is how it's supposed to work, but my client says it's not. She
has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if
she
typed 25 it would show up as .25 but now either way she types it the
result
is .25 and she wants it to be the way it used to be. So my question is
what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

does she have the range formatted as Percent?

"Carla" wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

It was formatted as general.

"Duke Carey" wrote:

does she have the range formatted as Percent?

"Carla" wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

"Carla" wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

If you click "Tools" options Edit. Check "Fixed Decimal" and set "Places"
to zero. This will allow you to get numbers as you typed them. Type "25,"
you get "25." Type "25.00," you get "25.00," etc. This applies to Excell
2003 but will undoubtedly work with earlier versions.

"Papasan" wrote:



"Carla" wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

Carla

Your client is correct if running 2003 version and I think 2002 also.

With FD enabled and set to 2 DP you can override this by adding the DP to the
number as your client states.

25. returns 25.00 if cell formatted as number or 25 if cell formatted as
General

25 returns 0.25 with either formatting.

Why not working............??

Maybe HelpDetect and Repair?


Gord Dibben MS Excel MVP

On Thu, 4 Jan 2007 19:22:01 -0800, Papasan
wrote:



"Carla" wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla

"Carla" wrote:

Maybe this is how it's supposed to work, but my client says it's not. She has
fixed decimal set under tools, options with 2 decimal places. However she
said in the past she could type 25. and it would show up as 25.00 and if she
typed 25 it would show up as .25 but now either way she types it the result
is .25 and she wants it to be the way it used to be. So my question is what
is the best way to do this and how is it supposed to work?

Thanks,
Carla