Southern Belle

Posts: n/a

how can i get a cell to hold a zero in front of a digit ie. 01 or.

I have tried checking the zero values box but still just takes the zero from
the front which I need for the table I am trying to plan. I don't want any
decimal points in front

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
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
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO	jnkell	Excel Worksheet Functions	2	December 18th 04 07:13 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
VLookup resulting in a blank cell...	KempensBoerke	Excel Worksheet Functions	1	October 28th 04 09:57 PM

All times are GMT +1. The time now is 12:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us