Formatting to show 0 as first number in a cell when input
Thanks guys. :)
"David Biddulph" wrote:
"triffidbook" wrote in message
...
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
Format the cell as text prior to entering the data.
--
David Biddulph
|