Posted to microsoft.public.excel.misc

Sanjeev

external usenet poster

Posts: 8

How can I get 0000 in Every Column N every Excel file by default?

Excel automatically truncates 00000 whenever I put 000001. I went to format
and formatted the cells. It works. But I open a new excel file...it does
again truncate 0000 from 00001.

I want to display 00001 in each and every Column. I want by default, for
evey excel file I create.

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
Excel 2003: cannot locate default file location	Spokaneman	Excel Discussion (Misc queries)	2	March 10th 06 07:17 PM
consolidation of tables in excel with text and figures	samenvoegen van sheets	Excel Worksheet Functions	8	March 2nd 06 03:27 PM
How do i set default column type as text in excel?	man_see	Excel Discussion (Misc queries)	1	November 7th 05 09:28 PM
VBA for Excel 2000 file is corrupt	nkamp	Excel Discussion (Misc queries)	0	May 26th 05 03:37 PM

All times are GMT +1. The time now is 07:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us