Format data

I have a formula in a cell =Sheet11!BD401&Sheet11!BE401&" / "&Sheet11!BF401&"C"   How do I format the value of Sheet11!BD401 to 000, and Sheet11!BE401 formatted to 00
Who is Participating?
NBVCConnect With a Mentor Commented:
I think, by your description, you want:

=TEXT(Sheet11!BD401,"000")&TEXT(Sheet11!BE401,"00")&" / "&Sheet11!BF401&"C"
Steven HarrisPresidentCommented:
Try using:

=TEXT(Sheet11!BD401&Sheet11!BE401, "000")&" / "&TEXT(Sheet11!BF401&"C", "00")
sandramacAuthor Commented:
Thank you
Steven HarrisPresidentCommented:
Thanks NB, I didn't realize there were three calls.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.