Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Otto Moehrbach
 
Posts: n/a
Default

Thanks Ron, I didn't know that. Otto
"Ron Rosenfeld" wrote in message
...
On Thu, 7 Apr 2005 11:15:55 -0400, "Otto Moehrbach"
wrote:

Brian
The ###### is usually an indication that the column is not wide enough
to display the number. Select a cell in that column and do Format -
Column - AutoFit Selection. Post back if this is not a solution for you.
HTH Otto


Otto,

The #######... is also an indication of negative time when using the 1900
date
system.


--ron



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
Calculating growth with negative numbers Tsipi4me Excel Worksheet Functions 3 April 3rd 23 12:12 PM
How do you enter a negative time number in Excel? Thomas99 Excel Discussion (Misc queries) 4 March 17th 05 11:42 PM
Calculating negative time & creating scrol bars for fixed size txt box. Jonathan hill via OfficeKB.com Excel Discussion (Misc queries) 4 February 12th 05 02:08 AM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 09:15 PM
negative time joshua Excel Discussion (Misc queries) 1 January 6th 05 06:41 PM


All times are GMT +1. The time now is 12:51 PM.

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

About Us

"It's about Microsoft Excel"