Zeros in a cell

[rhmkrmi]

Hello, How can I keep different numbers of zeros in a cell, for example, 000 or 000000 or 00000000.

When I use custom format, I am limited to the number of zeros that is customized but I need to have different number of zeros in a column cells.

Thank you.

 

[sandy666]

any real example? there are zeroes only or something more?

 

[rhmkrmi]

There are zeros only but different columns cells need to be populated with different number of zeros.

 

[sandy666]

something like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]00[/td][td]000[/td][td]00000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]00000[/td][td]0[/td][td]000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]000000[/td][td]0000[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]0[/td][td]00[/td][td]0000[/td][/tr]
[/table]

I'd like to see any example

 

[rhmkrmi]

Yes, exactly, thank you.


I could not paste an image in but we may have actual numbers in the same column too, for example:


00
0000
568541
000000
0
2515


Thank you.

 

[sandy666]

so change cell(s) format to text then enter your zeroes

 

[rhmkrmi]

Thanks.
In that case, I cannot sum them.

If there is no solution to this, how can I go about doing what you had in your example in #4 ?

Thanks again.

 

[sandy666]

of course you can SUM.

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]00[/td][td]333[/td][td]00000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]251[/td][td]0[/td][td]5[/td][/tr]

[tr=bgcolor:#FFFFFF][td]000000[/td][td]0000[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]30[/td][td]22[/td][td]0000[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

281​

[/td][td]

355​

[/td][td]

5​

[/td][/tr]
[/table]

=SUM(--A1,--A2,--A3,--A4)
or
=SUMPRODUCT(--A1:A4)

enter formula to the Totals Row, change format to General then re-enter formula by F2 + Enter then drag formula from the left to the right

 

[Fluff]

SUM will simply ignore text values

Book1
	G
4	1
5	00
6	3
7	0000
8	4
Lookup

Cell Formulas
Range	Formula
G8	=SUM(G4:G7)