Loosing Zeros
 

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

Try this, Axim. You'll want the format option.
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~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

see this post...

http://www.excelforum.com/showthread.php?t=380918

adjust the format to the number of zero places you need....

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380919