Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
eider
 
Posts: n/a
Default Number format exactly the same, displays differently in some cells

Are the values actually zero, or are they maybe just smaller than .05 and
round to 0.0? You could check by formatting cells as general or to many
decimal places. If they're small but not zero, you can use the round
function to actualy reduce them to zero.

"Kendall" wrote:

I've had this a few times before. I have a number format specifying to show
zeroes as a dash ("-" in number format). Some of the cells show the dash,
but others show 0.0.

I've tried changing the "zero values" checkbox in Options just in case that
created problem. I've tried copying/pasting custom formula in the incorrect
cells. I've tried manually adding a new custom format the same as the
correct cells. I don't know what else to try.

I'm in an acctng firm, so VERY important for official financial statements
to have the same formats in all the cells.

Please help.

  #2   Report Post  
Kendall
 
Posts: n/a
Default

Thank you--that's a good thought; however, they're actually zeroes, not
formulas at all.
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
default number format cmannaccountant Excel Discussion (Misc queries) 1 June 16th 05 09:36 PM
Custom number format always defaults last number to 0. scubadave Excel Discussion (Misc queries) 2 June 15th 05 10:20 PM
number format keeps dividing by 100 Frank Kabel New Users to Excel 0 December 29th 04 10:48 PM
How do i change numbers in text format to number format? Greg New Users to Excel 1 December 14th 04 06:22 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 09:14 PM.

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

About Us

"It's about Microsoft Excel"