Home |
Search |
Today's Posts |
#2
|
|||
|
|||
A couple of options:
Type the cell with a ` before entering the number or FormatCellCustomer.....in the Type: box enter 0000 or change the column to text "Tdilly" wrote: I'm trying to get certain cells to keep the zero in front of the numbers. ex: 123 s/b 0123 as typed... numerous cells of different lengths, all may not have a 0 in front, need to be displayed as typed instead of "0123" showing as "123" Tasha Dilwood Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a zero in front of a number in general format? | Excel Discussion (Misc queries) | |||
input text at front of field that contains data | Excel Discussion (Misc queries) | |||
export excel to Front Page | Excel Discussion (Misc queries) | |||
Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) | |||
how can i get a cell to hold a zero in front of a digit ie. 01 or. | Excel Discussion (Misc queries) |