Thread: [Solved] How can I retain Zero's (0) in front of #'s in Office 2010
View Single Post
 
Old 02-10-2011, 07:32 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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...
Reply With Quote