how do I custom format .0040 to show as 40 ?

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

Guest

I'm using Excel 2003. I want to custom number format .0040 to show as 40,
without actually changing it to 40.
 
The long silence confirms by suspension that what you want cannot be done,
best wishes
 
No! The OP wanted to enter 0.0040 and have 40 displayed in the same cell.
If you are to use anther cell why bother with Text, a simple =A1*1000 would
do!
best wishes
 

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

How to suppress leading zeros in Excel 2
number formatting 3
user defines macro to run 4
Convert numbers to hrs: min 2
Formatting time 6
Help with time formatting 2
Need data entered to reflect hh:mm format 3
insert picture 4

Back
Top