No Tags Found!

spandey2002
Hi,
Anybody can tell me how I can use zero before any number in Excel, I had seen this type of function in a Excel formula file but at this time I am unable to find this file.
please help.
satish pandey

From India, New Delhi
Madhu.T.K
4193

You mean putting a figure in a cell which starts with 'zero'?. If so,
please select the cell, go to 'Format- Cell, take the 'number' and select ' Text' in the Category. If you do so, the number given in the cell becomes exclusive which can not be added to get the total.
Please verify and consult another who is well versed in computer.
Regards,
Madhu.T.K

From India, Kannur
K.Ravi
54

if ur using 5 digit no u can use in format -- special -- zipcode function... it will compensate other digits by adding 0.
also the idea given by mr madhu tk is good but u cant perform mathematical operations or use formulae on those numbers as they would be just TEXT.
another thing u can do is also use formulae but first tell what u wanna do exactly better attach sample of what u want to do so that people can best advise ,,, u

From India, Pune
chandan2ykpankaj
11

My dear friendz it is very simple to put zero in front of your figure (any number starts from zero) you have to put ' this key button known as colon just second key button right to L key button. By this you can write any figure starts with zero and you can also calculate it with formula.
Enjoyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy yyyyy
and let me know it helps you or not !!
Pankaj Chandan

From India, New delhi
K.Ravi
54

Dear Pankaj, Could you simplify by providing a sample sheet or giving more details. I am not getting it. :icon6::icon6:
From India, Pune
K.Ravi
54

:icon6::icon6::huh::huh:@SPANDEYYYYY

look here bhai
Have you ever tried to insert 0 before sequel of numbers in Excel? You think that what’s the use of appending 0 before sequel of numbers because in mathematics 123 is same as 0123 but there are some areas where these two numbers are treated as different number. As in banks, if you have an account, definitely you have an account no. account no. is an entity which distinguishes you from all others so it must be unique to identify you. For example account no. 123 is different from 0123. Both the account no. belongs to two different persons, if you write 0123 in the cell of excel sheet, 0 will be automatically removed as we move to the next cell.

We can’t ignore zero as you know how it is important to us. You can add zero before any number by performing the following steps:

1. Open the [COLOR=#009900 ! important][COLOR=#009900 ! important]MS [COLOR=#009900 ! important]Excel[/color][/color][/color] worksheet.

2. Write the number in the cell before you want to add zero.

3. Right click the mouse in the cell, select Format Cells… option. Format Cells window will be displayed.

4. Select the Numbers tab from the window then click Custom option from the left Category: section.

5. Select 0 option from the Type section.

6. Type the no. of zeroes as many as your number contains digit. For example, your number is 12345, so now you need to enter five zeros after the selected 0 in the type section i.e. 000000.

7. Click OK. The number of zeros entered by you will be converted to digits and the result would be 012345.

From India, Pune
rahulverma2u
6

Dear , Very simple 1. go to Format cell > Number > Custom and put Zero you want applied and enjoy 2. Start with ' and put zero (it will conver in text) Reply please. Thnaks
From India, Ambala
rahulverma2u
6

Dear ,,

Have you ever tried to insert 0 before sequel of numbers in Excel? You think that what’s the use of appending 0 before sequel of numbers because in mathematics 123 is same as 0123 but there are some areas where these two numbers are treated as different number. As in banks, if you have an account, definitely you have an account no. account no. is an entity which distinguishes you from all others so it must be unique to identify you. For example account no. 123 is different from 0123. Both the account no. belongs to two different persons, if you write 0123 in the cell of excel sheet, 0 will be automatically removed as we move to the next cell.

We can’t ignore zero as you know how it is important to us. You can add zero before any number by performing the following steps:

1. Open the MS Excel worksheet.

2. Write the number in the cell before you want to add zero.

3. Right click the mouse in the cell, select Format Cells… option. Format Cells window will be displayed.

4. Select the Numbers tab from the window then click Custom option from the left Category: section.

5. Select 0 option from the Type section.

6. Type the no. of zeroes as many as your number contains digit. For example, your number is 12345, so now you need to enter five zeros after the selected 0 in the type section i.e. 000000.

7. Click OK. The number of zeros entered by you will be converted to digits and the result would be 012345.

MS excel file which contain transaction records, amount payable, amount receivable, inventory control records gets corrupt due to virus attacks, hardware malfunction, improper system shutdown, error in the disk, power failure and many more. To repair excel file and recover formulas, images, charts, clip art, flow charts, text, worksheets and workbooks stored in excel file, excel recovery software must be employed. To repair corrupt excel files, several excel repair software are available in market, which help you to recover important data from corrupt excel files. RecoveryFix for Excel is one such tool to repair corrupt excel file. For more information visit Repair Excel File - for Corrupt or Damaged Excel Files

From India, Ambala
Karpakam
Hi,
As mentioned by some of them, you may have to mention as to how you are going to use the data of numbers prefixed with ZERO. Another way to change a cell format into text is to enter apostrophe and then enter the number beginning with ZERO. However, as rightly mentioned by someone, you cannot sum the data.
Regards,
Karpakam


Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.