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: 5
Default How to make a number starting with 0 to keep showing it in Excel?

Example: When entering 0315684 into an Excel cell it then automatically
becomes 315684. How do you retain the 0?
 
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
excel chart showing movable graph at what point we make a profit Mim Charts and Charting in Excel 0 October 22nd 07 05:48 AM
how to format cell in excel for 12 digit number starting with a 0 lmattox Excel Discussion (Misc queries) 2 September 6th 07 09:14 PM
excel doest not shows the number starting with 0..is there is any way to solve this. naughtyboy Excel Discussion (Misc queries) 2 August 9th 06 08:01 PM
how do you make a summary page showing the workbook name with the excel sheet names carole New Users to Excel 1 May 22nd 06 08:31 PM
How can I make a formula in Excel showing when the file modified? TMark Excel Worksheet Functions 2 January 11th 06 11:02 AM


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