Hello all!
Straightforward question which I'm hoping has an easy answer.
I have a spreadsheet I manually fill out each day that captures manufacturing performance. The values are always whole numbers; ie, 51, 253, or 1,344, but when keying the values, I have to add the trailing 3 zeros to each number due to how the values need to be viewed by my leadership. So, the values will look like xx,xxx, xxx,xxx, or x,xxx,xxx. To minimize keystrokes and typos, I'd like to format the cell so that if I key just the whole number, the cell will show it with the trailing zeros and the hundreds & thousands separator. While I can get the cell format to include the trailing zeroes, for the life of me I cannot get a comma to separate the hundreds/thousands. I've tried numerous variations myself and surfed the web for solutions, but have come up empty. Without doing helper cells or columns, is it possible to accomplish this "in cell" with formatting?
Thanks!
Straightforward question which I'm hoping has an easy answer.
I have a spreadsheet I manually fill out each day that captures manufacturing performance. The values are always whole numbers; ie, 51, 253, or 1,344, but when keying the values, I have to add the trailing 3 zeros to each number due to how the values need to be viewed by my leadership. So, the values will look like xx,xxx, xxx,xxx, or x,xxx,xxx. To minimize keystrokes and typos, I'd like to format the cell so that if I key just the whole number, the cell will show it with the trailing zeros and the hundreds & thousands separator. While I can get the cell format to include the trailing zeroes, for the life of me I cannot get a comma to separate the hundreds/thousands. I've tried numerous variations myself and surfed the web for solutions, but have come up empty. Without doing helper cells or columns, is it possible to accomplish this "in cell" with formatting?
Thanks!