LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default numbers starting with 0

I have a group of 6 digit numbers starting with "0". When I enter this in
the cell, it shows up in the cell correctly. BUT up above the 0 gets
dropped. I need the 0 to stay there. What can I do so the 0 does not drop
off in the top box.
 
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
Store numbers starting with zero as 2 digit numbers twisted1825 Excel Discussion (Misc queries) 8 January 11th 07 06:41 PM
How do I quadruple numbers starting with 1, 2? frenchy Excel Discussion (Misc queries) 10 September 16th 06 11:11 PM
how can i move the starting point for the numbers numbers down. Gold9er Setting up and Configuration of Excel 1 November 22nd 05 10:09 PM
how do i enter numbers starting with zero in excel achitsyerself Excel Discussion (Misc queries) 3 May 12th 05 08:21 PM
how do I put in line numbers in the first colum starting in row A. Bernie Excel Discussion (Misc queries) 2 January 12th 05 11:07 PM


All times are GMT +1. The time now is 02:55 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"