# Convert Percentage to 5 digit number without decimal point

1. ## Convert Percentage to 5 digit number without decimal point

hello all and thank you in advanced.

I have a upload process where I have to upload percentages as a 5 digit number with no decimal points and I'm having troubles getting excel to do this and retain all characters and would appreceate some help.

Examples

- Original Number = 6.8% (0.068)
- Needs to Display as = 00680

- Original Number = 7.2%
- Needs to Display as = 00720

- Orignal Number = 10%
- Needs to Display as = 01000

- Orignal Number = 150%
- Needs to Display as = 15000

The issue is I need it to completely remove the decimal and keep any leading or trailing zeros.

thoughts appreceated.

thanks again.

2. ## Re: Convert Percentage to 5 digit number without decimal point

 Row\Col A B C 1 6.80% 00680 B1: =TEXT(10000*A1, "00000") 2 7.20% 00720 3 10% 01000 4 150% 15000

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1