Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text format and missing value.
I have a column of reference numbers, there should be 6 numbers in
each reference, sometimes the leading number is a zero. I am using =TEXT(B2,"000000") to show all of the digits. Sometimes the reference column is blank and if that is the case then i do not want to see 000000 but rather have it show as blank. If it was still a number column i could have used =IF(B21;B2;" ") Could somebody show me the best way to combine these two items so as to show a 6 digit number in column B unless the original field was blank in which case the new field should also be blank. with thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2K3 Scroolbar Format Control missing a tab. | Excel Discussion (Misc queries) | |||
Missing Text in a List Box | Excel Discussion (Misc queries) | |||
Missing tabs in Format Cells Menu | Excel Worksheet Functions | |||
Missing text in a cell? | Excel Discussion (Misc queries) | |||
Missing format and symbols | Excel Discussion (Misc queries) |