ExcelBanter - How can zero be displayed in Excel as the first number

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

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

- - How can zero be displayed in Excel as the first number (https://www.excelbanter.com/excel-discussion-misc-queries/42877-how-can-zero-displayed-excel-first-number.html)

Kevin

How can zero be displayed in Excel as the first number

Paul Sheppard

Kevin Wrote:

Hi Kevin

Either format the cell as Text or enter '0???, beware the numbers
cannot then be used in calculations

--
Paul Sheppard

------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=400192

All times are GMT +1. The time now is 02:47 PM.