Help! - Formatting Comps
MBA that is about to hit the desk. As part of our training, we are doing sample projects for our team. One of the exercises is a comps output. Right now my formatting is as follows:
10.4x
9.8
My decimals aren't aligned. I know the decimals need to be aligned, but I can't figure out the custom formatting code to align it (our bank doesn't add the separate column for the x). Any help would be greatly appreciated!
Custom formatting, type -> “0.0x”
It seems like you would need to custom format the non x digits with 0.0_x. This adds a space to the number from the right side that equals the width of your multiple x. Also make sure your multiple format is 0.0x to match.
Sheesh man good luck with the rest of the year lmfao
Beatae consequatur ea voluptatem accusamus qui repudiandae expedita. Vel qui praesentium nam velit blanditiis. Rerum est deleniti inventore laudantium. Quis voluptate maxime ut magnam. Tenetur laudantium consectetur molestias modi ullam. Perferendis sed voluptatibus est voluptates aliquid ad. Dolorem provident cum quisquam eaque minus quia rerum numquam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...