Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
replacing only zeros | New Users to Excel | |||
Excel file saved as csv - dropping zeros | Excel Discussion (Misc queries) |