0
   

Excell display leading zero

Forums: Computers
Email this Topic • Print this Page
 
 
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 to this Topic
Type: Discussion • Score: 0 • Views: 608 • Replies: 3
No top replies

 
the prince
 
  1  
Reply Thu 1 Feb, 2007 07:45 am
Format Cell
Custom
0###
0 Replies
 
dadpad
 
  1  
Reply Thu 1 Feb, 2007 03:56 pm
Thank you Prince.
0 Replies
 
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
Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
Mac help/can't install new printer, don't remember passwd - Discussion by ossobuco
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » Excell display leading zero
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.04 seconds on 05/05/2024 at 08:33:53
▲ ▼