ExcelBanter - how do i get excel to NOT take zero's of the front of a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i get excel to NOT take zero's of the front of a number (https://www.excelbanter.com/excel-discussion-misc-queries/13013-how-do-i-get-excel-not-take-zeros-front-number.html)

tor

how do i get excel to NOT take zero's of the front of a number

Bob Phillips

Use a custom format of say 000000

--

HTH

RP
(remove nothere from the email address if mailing direct)

"tor" wrote in message
...

Cindy

Try using an apostrophe before you enter your number. HTH Cindy

"tor" wrote:

All times are GMT +1. The time now is 01:10 AM.