Zero drops at the end of a number

Ms Bee

New Member
Joined
Oct 6, 2006
Messages
1
I upload a list of reference numbers from a website into an excel spreadsheet. If this number has a zero at the end of it, excel will drop it. For example if the number should read 4445550, excel will show 444555. My reference numbers are both 4445550 and 444555 so I can't assume that a zero should be placed there. If I save this file from the website into a text file the number will show correctly.

Is there a way to format the cells so that it shows all the characters given?

Thank you for your help!!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
Hi -

Welcome to the board.
the question is, how would you upload the file? is it using web query or something? would it be possible to provide the link to the site you're talking about?
 

Forum statistics

Threads
1,175,848
Messages
5,899,819
Members
434,799
Latest member
Mussala

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top