Custom Number Formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Gotta list:

0.25
0.75
1.00
0.50

Want these to appear as follows when typed into a cell (no matter which one
is typed in), preferrable right-aligned:

..25
1.0
..75
..5


Is there a custom format that can be used for this? Thanks. _c
 
#.0#

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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

Multiple row 4
Conditional Formating Issue 1
Rounding number to 0.25 ? 5
Pivot Tables + Color + Dynamic Content generation and display 2
Sumif function using the "conditional sum wizard" 1
help with auto sum 4
Commission Calculation with IF Stmt. 2
MS Access 2003 Formatting Hours Field 2

Back
Top