Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
As of today (it's never happened before) a spread sheet that I'm been
adding to will now delete leading zeros if they are typed or pasted into any cell. So if I enter 0067, it turns it into 67. I don't want this. I've looked at cell formatting, auto formatting, conditional formatting, and can't find out what's making this happen or how to turn it off. I even tried Paste Special, and picked Text, which should paste the text exactly as it is and leave it alone, but it still changes it. OK, maybe I'll feel stupid when I find the answer, but it's driving me crazy. So what's the trick? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
Auto Complete not completing | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
How Do I stop Auto Unhiding Rows? | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |