Text format and missing value.

  • Thread starter Thread starter Box666
  • Start date Start date
B

Box666

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(B2>1;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
 
I'm confused. What does =IF(B2<1," "," ")&... do for us? Doesn't that
merely concatenate a space at the beginning of the string, regardless of the
value of B2?
 
Your wright, not my day, posting to fast and not checking what i'm writting.
Same for the other post, going back to bed!!!
Thanks for the correction
Regards
Cimjet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Match two columns/rows within multiple sheets then paste answer... 0
Referencing a cell. 1
IF Statement Problem 4
Date and If problem 6
= IF blank 3
How to Combine two cells (numbers) but not add 7
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
help on a vlookup please 5

Back
Top