#1   Report Post  
Old January 16th 08, 04:14 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 77
Default ####

What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.

  #2   Report Post  
Old January 16th 08, 04:23 PM posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,998
Default ####

See the HELP section for a good explanation of the ####. It could be that
your column is just not wide enough to display the entry.

If you are trying to add LEADING zeros to a string, type an apostrophe
first. It will not show up on the cell, only in the formula bar, and changes
the cell format to TEXT. Or, you can just format the cell for TEXT before
inserting the leading zeros.

Vaya con Dios,
Chuck, CABGx3



"Teri" wrote:

What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.

  #3   Report Post  
Old January 16th 08, 04:23 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default ####

A cell with ##### generally indicates the column is not wide enough to
display the value stored: make the column wider by pulling the bar between
the column headers (to make column B wider, pull the bar between B and C) 0r
use Format Column and change the width. A negative date value can also cause
cell to show ###

If you want to see 0123 and not 123: type a single quote (') then the digits
OR format the cell with Custom Format 0000.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Teri" wrote in message
...
What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.



  #4   Report Post  
Old January 16th 08, 04:26 PM posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default ####

one guess on your 2nd question
..Also, how do I add ZERO's? When I add a ZERO, it is not included.

Type a preceding apostrophe if you want leading zeros
eg: enter it as '090
The apostrophe won't display in the cell, but it'll become a text number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #5   Report Post  
Old January 17th 08, 12:55 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default ####

One more suggestion for the #### could be negative date or time.

And another.

If you have between 255 and 1024 characters in the cell and are formatted to
Text, you will get the #####.

If that is the case, format to General.


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 07:14:01 -0800, Teri wrote:

What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.




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



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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017