LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Turning off auto formatting

I am using several excel sheet to report on a rather large PO system. Many
customers have preceding zeros on their POs, while others do not, and being
that different customers have several different numbering systems, I cant
just arbitrarily format all cells a certain way. So,to avoid further
headaches, can I diable the built in formatting that wants to delete
preceding zeros? If so, can someone tell me how this is done please.
Thankyou.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Turning off all Automatic Formatting in Excel 2003 Adam M Excel Discussion (Misc queries) 0 November 4th 05 01:07 PM
importing XML, auto formatting smoran Excel Discussion (Misc queries) 0 October 4th 05 11:19 AM
Formatting Auto Shapes - Rectangle Woody13 Excel Discussion (Misc queries) 1 May 19th 05 07:50 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM


All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"