| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Leading Zero
Need some Help. Trying to include leading zeros into my inputs. eg "1234" to display "0001234" and "Sample product" to display "00Sample0product" I was able to do this for the numbers but was not able to display preceeding 00 and inserting 0 for blank space Further more when I combine the different cells via "CONCATENATE" function I found the preceeding zeros disappearing. Can someone please help? Thanks Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
| cell format problem | Excel Discussion (Misc queries) | |||
Threaded Mode
