ExcelBanter - Excel cell format

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

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

- - Excel cell format (https://www.excelbanter.com/excel-discussion-misc-queries/3904-excel-cell-format.html)

rockfam8

Excel cell format

how can i display preceding zeros in excel without formatting as text?

Domenic

In article ,
"rockfam8" wrote:

how can i display preceding zeros in excel without formatting as text?

Precede your entry with an apostrophe. For example...

'012345

Hope this helps!

Dave Peterson

Or give it a custom format like

00000

(as many 0's as you need)

rockfam8 wrote:

how can i display preceding zeros in excel without formatting as text?

--

Dave Peterson

All times are GMT +1. The time now is 11:10 PM.