Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Zero
Try clicking the Format button next to the "Replace with" field and set a
Custom Format of 00 there. After doing that, you can just specify 6 as the "Replace with" entry as the Custom Format will handle adding the leading zero for you. Rick "Beebolbod" wrote in message ... Hi, Why when doing search and replace against variable xxx with a value such as 06 does xxx always end up as 6? I want to preserve the leading zero. I've changed the format of the cells to no avail. Any ideas? BR Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#Missing | Excel Worksheet Functions | |||
What am I missing here??? | Excel Programming | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
Am I missing something??? | Excel Programming |