Posted to microsoft.public.excel.misc

external usenet poster

Posts: 4

Leading Zero as value not appearance

When i use formatting cell custom with 0000 i manage to add leading zero but
the problem is the leading zero only as appearance. Is it possible to make it
as value in the cell

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
2 questions on appearance	stew	Excel Discussion (Misc queries)	5	October 13th 08 04:22 AM
appearance of a concatenated value	Jan Buckley	Excel Worksheet Functions	0	November 15th 06 09:29 PM
Excel Appearance	Anonymous	Excel Discussion (Misc queries)	2	September 19th 06 09:22 PM
Cell appearance	wisey_1	Excel Discussion (Misc queries)	3	July 19th 06 12:04 AM
Cursor Appearance	Mjohnson	Excel Discussion (Misc queries)	1	November 9th 05 04:28 PM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us