LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
lauren
 
Posts: n/a
Default I want to display the number 0 first in a cell, it won't let me n.

I want to be able to see a number with a zero in front of it as in 019, no
decimals or anything but everytime I enter it and move to the next cell the 0
automatically disappears. Can anyone help?
 
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
How to make the cell or font color red if the number is negative? Bob T Excel Worksheet Functions 6 August 18th 05 01:28 PM
Excel should let me circle a cell or number in the spreadsheet fo. BTaylor Excel Discussion (Misc queries) 2 March 8th 05 03:00 PM
How do I display an insignificant 0 at the beginning of a number nuttylocke Excel Discussion (Misc queries) 2 February 9th 05 12:55 PM
insert a page number into a cell? Carrmuha Excel Worksheet Functions 2 November 13th 04 07:09 AM
cell that accepts a whole number or five place deciaml crck_whr Excel Worksheet Functions 2 November 12th 04 04:14 PM


All times are GMT +1. The time now is 08:24 AM.

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

About Us

"It's about Microsoft Excel"