how do i remove zero's from column of cells

Dominic · Dec 28, 2004

I have a column of cells that have a number that includes zero's. I would
like to remove the zero's from all the cells in the column.

Rick B · Dec 28, 2004

Are you talking about ACCESS? or EXCEL? Column and Cell are Excel terms.
If you are talking about Access, what type of field is it? Text, Number?
Are you in a query, a form, or a table view?
More info please.

Rick B

Arvin Meyer · Dec 28, 2004

Dominic said:
I have a column of cells that have a number that includes zero's. I would
like to remove the zero's from all the cells in the column.

Try a query:

Update MyTable Set Mycolumn = Null Where MyColumn = 0;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access