how to eliminate ####sign and shortcut signs..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ie1: For instance keyed in 11111111111 in the cell, endup displaying
1.111111E+17
Qns: How to display my desired data which is '11111111111'.

ie2: Intend to key '111,112,113....120' on cell, given 'pre-adjusted' column
and numbers continue on next row below and next. Given '111,112....120' taken
up 3rows and able to fill ideally,without the outcome shown ###### sign.
'Resize' column/row adviced, i just wanted the numbers to fill in my
pre-adjusted field
 
Preformat that cell as Text or start your entry with a leading apostrophe:

'123,123,123,123,123,123,123...
 
Sorry for the insufficient detail
Assume i wanted to work on 'column D' which i extend the width. i physically
dragged to lengthen twice its original length.
Basically i wanted to key in the detail (132,133,134...145), for which it
wouldnt overlap to 'column E', rather it continue on A2, A3 below. And still
detailed at 'Column D'

as for merging, i highlighted A1,A2,A3 and click format cell, under
Alignment..i checked on 'Wrap text' and 'Merge cells' and selected 'Top' for
vertical:

i tried to add ' sign before the numeric number and it works. Wonder whether
one have to insert this sign upon encountering insufficient column width
where #####appeared??
 
First, if you keep the entry numeric, then you have a problem:
Excel only keeps track of up to 15 digits--so everything after that 15th will be
turned to 0.

And when you're working with numbers, excel assumes that they're all on one line
in the cell.

You could try this (just out of curiosity--it won't help).

Format|Cells|Number tab
custom category
00000000000000000000000(alt-0010)00000000000000000000000
(hit and hold the alt key while typing 0010 on the numeric key pad -- and don't
type the ()'s.

Now type some long number in that cell (no apostrophe, though).

Widen the column and adjust the rowheight and you'll see:

12341234123412300000000
00000000000000000000000

But that column has to be very wide. As soon as you skinny it up, you'll see
the ###'s showing up--way before you think it needs to. But right when excel
knows when that long number would be if it were on one line.

======
If you want to enter text (start with that leading apostrophe), you can force a
new line within the cell by hitting alt-enter where you want. (You won't have
to worry about where excel will create the new line.)
 
Back
Top