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