Thread: Formatting to show 0 as first number in a cell when input
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Formatting to show 0 as first number in a cell when input
One way ..
Assuming its a 5 digit series (00000)
Select the col,
Click Format Cells Number tab
Choose Custom, type: 00000
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"triffidbook" wrote:
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