ExcelBanter - View Single Post

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