ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to stop numbers turning to hash ? (https://www.excelbanter.com/excel-discussion-misc-queries/163958-how-stop-numbers-turning-hash.html)

Oliver Swadkin

how to stop numbers turning to hash ?
 
please it is urgent


Tyro[_2_]

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




Ken Wright

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




Dave Peterson

how to stop numbers turning to hash ?
 
Or use a smaller font.

Oliver Swadkin wrote:

please it is urgent


--

Dave Peterson


All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com