Excel Decimal Places

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

How can a cell or series of cells be formatted to place
the last 2 numbers enter to the right of the decimal and
not have the entire sheet formatted that way?
 
Hi
if you don't wnat to use the option 'fixed decimals' this can't be done
with a format. You'll need VBA for this (an event procedure)
 
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
Addition errors with Decimal Places 5
Conditional Formatting Formula Not Working 1
problem with number format with 2 decimals? 5
formula for decimal point 4
Formula calculating to the 3rd decimal 9
Change number from multiple decimals to 2 3
Excel Excel 2007 won't stop rounding down my formula results! 5

Back
Top