1
   

Excell display leading zero

Tags: Computers
Email this Topic • Print this Page
 
 
Post: # 2,508,828
View Profile dadpad
 
Reply Thu 1 Feb, 2007 07:36 am
When I type 0875 into the cell it is displayed as 875. How can I format the cell to display a leading zero without formatting the cell as "text" or including a text marker such as a comma.
  • Topic Stats
  • Top Replies
  • Link/Embed
Type: Discussion • Score: 1 • Views: 96 • Replies: 3

 
Post: # 2,508,835
View Profile the prince
 
  1  
Reply Thu 1 Feb, 2007 07:45 am
Format Cell
Custom
0###
0 Replies
 
Post: # 2,509,302
View Profile dadpad
 
  1  
Reply Thu 1 Feb, 2007 03:56 pm
Thank you Prince.
0 Replies
 
Post: # 2,509,725
View Profile the prince
 
  1  
Reply Fri 2 Feb, 2007 02:07 am
You are welcome daddy'o....

During thebudget season, I spend most of my time on excel and powerpoint - happy to help !
0 Replies
 
 

Related Topics

Super cool computer tricks, for dopes like me. - Discussion by OCCOM BILL
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Blue screen of Death - Question by dagmaraka
How does one uninstall a program? - Question by Woollcott
how do you type pi? - Question by C99
Conficker worm - Discussion by msolga
SYSTRAY MISSING - Discussion by Misti26
Broad Jump Client Foundation - Discussion by Mustang
Caught in loop trying to upgrade to IE6 using Windows Update - Discussion by nimh
[OLD] Spyware, Browser Hijacks, Yuckware? Check here 1st - Discussion by timberlandko
Best Security Freeware - virus, spyware, spam removal, etc. - Discussion by Monger
 
  1. able2know
  2. » Excell display leading zero
Copyright © 2009 Horizontal Verticals :: Page generated in 0.34 seconds on 11/28/2009 at 03:09:25 Top End