Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how to stop numbers turning to hash ?

please it is urgent

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default how to stop numbers turning to hash ?

Numbers appear as hash marks (#'s) if your column is not wide enough or if
you have an invalid date. Just make your column wider.

Tyro
"Oliver Swadkin" <Oliver wrote in message
...
please it is urgent



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 634
Default how to stop numbers turning to hash ?

Widen the column perhaps?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Oliver Swadkin" <Oliver wrote in message
...
please it is urgent



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default how to stop numbers turning to hash ?

Or use a smaller font.

Oliver Swadkin wrote:

please it is urgent


--

Dave Peterson
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
How can I stop Excel from turning the number ranges I enter (eg 1. jenny New Users to Excel 1 October 11th 06 09:53 PM
How do I stop Excel from turning November 2006 into Nov-06? Jessamine Excel Discussion (Misc queries) 2 May 23rd 06 06:42 PM
How do I stop a number from automarically turning into a date? Ed Excel Discussion (Misc queries) 2 February 23rd 06 01:35 PM
stop (1) from turning into -1 Ferral Excel Discussion (Misc queries) 2 September 30th 05 12:33 PM
how do i stop excell from turning the last five digits in a 20 di. cingularws Excel Discussion (Misc queries) 1 March 29th 05 03:07 AM


All times are GMT +1. The time now is 11:31 AM.

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"