ExcelBanter - Loosing Zeros

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Loosing Zeros (https://www.excelbanter.com/excel-worksheet-functions/31862-loosing-zeros.html)

Axim Relaxing

Loosing Zeros

Anne Troy Wrote:
Try this, Axim. You'll want the format option.
http://tinyurl.com/73h4l

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

"Axim Relaxing" wrote
in
message om...-

Hi

I have recently imputed on an excel sheet. Example 000123. When I
press
return I loose the zeros. What can I do to stop this? I am told that
if
I format the cell to text this won’t happen BUT… I will not be able
to
apply any calculations to that cell.

I would like to still have the option to apply calculations. Is there
a
solution?

Thanks

--
Axim Relaxing-
@ Anne Troy
Many thanks for you help that has solved it. Very much appreciated.

Thanks.

--
Axim Relaxing

All times are GMT +1. The time now is 09:08 AM.