HCBBS Forum (English)
Submit Chemical Projects / Find Solutions
Amplify Your Requirements on a Broader Chemical Platform *Engineering · Technology · Equipment · Solutions*
Submit Request

How to enter 0913 in EXCEL?

2010-08-20View Original

Thread Content

This post was last edited by Final Fantasy on 2010-10-26 18:58 I want to know how to enter 0913 in EXCEL? Every time I enter it, it is 913. I don’t know how to get this 0. Please help!
Reply #22010-08-20
I did what you said, why doesn’t it work? Or am I mistaken
Reply #32010-08-20
Select the cell where the data is located--Cell Format--Number--Text--Enter the number and it's OK.
Reply #42010-08-20
:(Reply 3# ms3210 Why can’t I enter numbers? There is no place to change it!
Reply #52010-08-20
Just follow the instructions on the 3rd floor. . . . Or there is something wrong with your OFFICE software
Reply #62010-08-20
Reply 4#mablejie How could this happen? Tell me in detail!
Reply #72010-08-20
Hey,,, blame me for being stupid! I entered numbers into the cell format! It should be in the cell! What was said above is correct! :loveliness:
Reply #82010-08-20
There is another way: Enter '0913, which means adding a single quotation mark in front of it, and then entering the number.
Reply #92010-08-30
Just change the number format to text format

Submit a Project

**Looking for Chemical Technology, Equipment & Solutions?** No Registration Required Broader Platform Exposure | Global Chemical Service Provider Connections

Submit Request — Free Consultation

Disclaimer

This is an automated machine translation of the original thread. Some technical terms may have inaccuracies; the original text shall prevail. Click "View Original" at the top right to access the source page, which supports IP-based automatic real-time language translation. Please watch out for contact details and sales inducements to prevent fraud. All content and translations are for reference only, representing solely the poster's personal views. For enquiries, email service@hcbbs.com.