Decimal Formatting

  • Thread starter Thread starter Paul Smith
  • Start date Start date
P

Paul Smith

Is there any way to format a column so that the decimal places line up,
without adding decimal places to figures that do not have them, i.e. turn...

219.4
306
180.3
219.2
198

into

219.4
306
180.3
219.2
198
 
Can you live with:

219.4
306.
180.3
219.2
198.

(Note the decimal points on the whole numbers)

If yes, then give it a custom format of:
#,##0.???
 
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

Access stripping decimal places in query 1
Excel chart from a table 5
how to insert same row numbers in several function statement 1
Look Up Multiple Values in a Column based on single Criteria 3
Decimal point in bar chart and similar 1
How to retain decimal zeroes? 5
formatting question 3
Zeros after the decimal 7

Back
Top