how do i remove zero's from column of cells

[Guest]

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]

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]

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

 

[Joseph Meehan]

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.

It sounds like you are working in Excel. Sorry. This is the Microsoft
Access Database newsgroup. It appears your question is not related to that
database. You are much more likely to find someone with the answer if you
post your question to a newsgroup devoted to your subject.