Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 05, 06:29 PM
Sam Brauen
 
Posts: n/a
Default decimal point override does not work

Is there any update to dload or anything? I work in excel all day everyday
and this is very annoying to have to add ".0" or "00" to everything.

I am running Office 2003 on Windows xp

"Debra Dalgleish" wrote:

If you're using Excel 2003, the override doesn't work as expected. 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 will be entered as 33

AL wrote:
I have fixed decimal point option on, but when I want to override the fixed
decimal point by placing a "." after the number I enter, it still places the
decimal point. For example: I want to enter the number 4,655.00 so I type
"4655." and I get 46.55. I do still want the fixed decimal point, but when I
have numbers that are #.00 I do not want to have to add "00" to every number.



--
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
all the cells in excell put 2 decimal points in all numbers no ma. carroll616 Excel Discussion (Misc queries) 4 December 1st 05 05:01 AM
Service work order schoolgeek63 Charts and Charting in Excel 1 January 7th 05 09:07 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 02:07 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 4 January 5th 05 02:07 PM
Import chart to Power Point and Macro problem Woody13 Excel Discussion (Misc queries) 1 December 8th 04 06:47 PM


All times are GMT +1. The time now is 08:28 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017