Thread: How do I change the format to allow a zero as a first digit?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I change the format to allow a zero as a first digit?
Either precede your entry with an apostrophe, or pre-format the col as TEXT
--
Max
Singapore
---
"MongoTom" wrote:
When I input an ID number, they all start with a zero. Excell automatically
removes it. How do I turn off this function?
Reply With QuoteReply With Quote