LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 192
Default Leading 0's disappear

Ok, heres my dilema, I deal with a lot of serial numbers, many of which begin
with a 0, and well it is very time consuming to go through and enter '0
infront of all of them. Is there any way to turn off the auto-correct
feature that gets rid of leading zeros in my cells?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gridlines disappear stucker Excel Discussion (Misc queries) 1 January 4th 08 04:59 PM
Links disappear Dave Links and Linking in Excel 4 February 4th 07 07:02 PM
How do I make it disappear? Ralphael1 New Users to Excel 1 October 12th 05 12:19 AM
New formula ## does not disappear Tink Excel Discussion (Misc queries) 1 June 9th 05 02:22 AM
Add-Ins disappear Gates72 Setting up and Configuration of Excel 0 December 2nd 04 04:06 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"