Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 10:19 PM
jroyv
 
Posts: n/a
Default How do I override fixed decimal place settings in EXcel 2003?

I have just upgraded an entire Tax/Accounting office to Excel 2003, and they
are very unhappy about this little change.

With fixed decimal set to 2 places:
In office 2000 when you entered 20. you got 20.00
In office 2003 when you entered 20. you get .20
In office 2003 when you entered 20.0 you get 20.00

It may not seem like much but when you do thousands entries a day an extra
key stroke on half of them is a big deal.

Any chance this will be fixed?

"Debra Dalgleish" wrote:

Formatting won't help in this case. The question is about entering data,
when the Fixed Decimal option in on (ToolsOptions, Edit tab)

John Armenia wrote:
you could just change the cell format to the format you want.

John


"Debra Dalgleish" wrote in message
...

You can add a decimal and a zero at the end of the number, to override
the fixed decimals. For example, type 33.0 and it well be entered as 33

CPAMichael wrote:

How do I override fixed decimal place settings in EXcel 2003? The

override

function does not work (pressing the decimal key after enterung the

number in

a cell.)



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



  #3   Report Post  
Old February 11th 05, 07:07 PM
Bzltyr
 
Posts: n/a
Default

Sorry I cannot help. I just want to add my disgust at this "upgrade." As an
accountant the problem gets worse when you click into a cell and then leave
that cell and 20 turns into .20. Try explaining that to a client.

"Michael" wrote:

Well thank you. I thought it wa me and I wias misssing something. I guess I
will reinstall Excel 2002 So I can actually save time by using the program.

"Frank Kabel" wrote:

Hi RD
yes, Excel 2003 is different than the previous versions for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Ragdyer" schrieb im Newsbeitrag
...
I don't have this problem.
Did Redmond change this for '03 Debra?
--
Regards,

RD

---------------------------------------------------------------------

------
Please keep all correspondence within the NewsGroup, so all may

benefit !
---------------------------------------------------------------------

------
"Debra Dalgleish" wrote in message
...
You can add a decimal and a zero at the end of the number, to

override
the fixed decimals. For example, type 33.0 and it well be entered

as 33

CPAMichael wrote:
How do I override fixed decimal place settings in EXcel 2003?

The
override
function does not work (pressing the decimal key after enterung

the
number in
a cell.)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 06:29 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 09:36 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 11:20 PM
Decimal places in Excel 2003 EXCELNCBOY Excel Worksheet Functions 6 November 5th 04 04:39 PM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017