Thread: Formatting to show 0 as first number in a cell when input
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
triffidbook triffidbook is offline
external usenet poster
  
Posts: 18
Default Formatting to show 0 as first number in a cell when input
How do I format a cell so it automatically shows a 0 as the first digit when
I input a numeric value insted of using the ' prefix? The cell is used for
order numbers which can begin with a 0
Reply With QuoteReply With Quote