Microsoft Excel help needed
Not Ducati related but I'm trying to put a number into an Excel database with a "leading zero" I can do this as text but then cant use a numeric function on it. I'm trying to show 03050601 which is a date code with up 01 to 99 additional identifiers. I want to type in 03050601 into a cell then beneath that cell put =thatcell+1 then copy that down the list adding one at a time to the sequence.
Trouble is that if I select "number" as the format the leading zero dissapears when the number is typed in.
I'm sure I've done this successfully before but can't remember how.
HEEELLLPPPP !!