front end zero - ExcelBanter

Tdilly

Posts: n/a

front end zero

I'm trying to get certain cells to keep the zero in front of the numbers.
ex: 123 s/b 0123 as typed...
numerous cells of different lengths, all may not have a 0 in front, need to
be displayed as typed instead of "0123" showing as "123"

Tasha Dilwood

Thanks!

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
How do I add a zero in front of a number in general format?	dvs	Excel Discussion (Misc queries)	1	July 2nd 05 11:31 PM
input text at front of field that contains data	Steve M	Excel Discussion (Misc queries)	3	May 16th 05 12:28 AM
export excel to Front Page	judithbear	Excel Discussion (Misc queries)	0	March 26th 05 11:17 PM
Microsoft Excel tries to load front page on opening	Excel and Front Page	Excel Discussion (Misc queries)	1	March 21st 05 08:51 PM
how can i get a cell to hold a zero in front of a digit ie. 01 or.	Southern Belle	Excel Discussion (Misc queries)	2	February 2nd 05 09:56 PM

All times are GMT +1. The time now is 03:46 PM.

Menu

About Us