LinkBack URL
About LinkBacks
BecParko 
How do we format a number that has decimal values without showing the decimal point?
For example 300.25 needs to be displayed as 0030025
Or 4028 needs to be displayed as 0402800
Thanks !
How do we format a number that has decimal values without showing the decimal point?
For example 300.25 needs to be displayed as 0030025
Or 4028 needs to be displayed as 0402800
Thanks !
If your numbers are in column A, try this, select B1, right click > Format Cells..> Number, select Custom and in the Type: box enter 7 zeros > OK.
Then enter this formula in B1
=A1*100 and copy down
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks