How can I retain Zero's (0) in front of #'s in Office 2010

		Microsoft Office Forums > Microsoft Excel > Excel
How can I retain Zero's (0) in front of #'s in Office 2010

FAQ

Thread Tools

Display Modes

02-10-2011, 07:32 AM

Colin Legg Colin Legg is offline

Windows 7 32bit How can I retain Zero's (0) in front of #'s in Office 2010

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Hi,

If the numbers are always five digits then you could use a custom format of 00000

Else, your options are to begin the number entry with a ' or to format the cells as text before entering the numbers.

Hope that helps...

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2003 will not retain password	TRSmith	Outlook	8	12-08-2014 07:17 PM
Upgraded from Office 2007 to Office 2010, now can't open Outlook	MDuff	Outlook	2	01-27-2011 01:06 PM
Outlook Question When Migrating From Office 2007 To Office 2010	swassociates	Outlook	3	01-01-2011 07:39 PM
License Office Standard 2010 and Home and business 2010	papypaul2	Office	0	11-05-2010 08:55 AM
MSWord Placeholders Bug; replaced pics don't retain position	za105	Word	0	01-23-2009 10:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:13 AM.