Bennos

Posts: n/a

Displaying the zero value in a cell

Is it possible to display a zero at the front of a series of numbers in a
cell?

Eg. "0123" is displayed as "123". How to display as original "0123"?

I've got the 'zero value' checked in Tools - Options - View. That is only
for a zero value in a cell without any other numbers in that cell.

Thanks in advance!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Function syntax to compare cell contents	ES	Excel Worksheet Functions	2	May 18th 05 03:53 PM
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM
Syntax for inferred cell references	donesquire	Excel Worksheet Functions	4	April 4th 05 09:29 PM
Displaying the results of multiple formulas in a single cell.	gallegos1580	New Users to Excel	1	January 12th 05 04:14 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM

All times are GMT +1. The time now is 08:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us