ExcelBanter - How do I keep the 0 at the beginning of a number, ex. 090?

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I keep the 0 at the beginning of a number, ex. 090? (https://www.excelbanter.com/new-users-excel/164160-how-do-i-keep-0-beginning-number-ex-090-a.html)

linds.hope

How do I keep the 0 at the beginning of a number, ex. 090?

Sandy Mann

How do I keep the 0 at the beginning of a number, ex. 090?

Pre-format the cells as text or precede it with an apostrophe

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

Replace @mailinator.com with @tiscali.co.uk

"linds.hope" wrote in message
...

All times are GMT +1. The time now is 06:59 PM.