ExcelBanter - Format Cells

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

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

- - Format Cells (https://www.excelbanter.com/excel-discussion-misc-queries/138192-format-cells.html)

Format Cells

I am trying to get a way of fformatting a cell with 4 trailing zeros... at
the moment I can opnly seem to get leading zeros...

I woul like to see the following:

12 becoming 120000 not 000012...

Regaards

David Biddulph[_2_]

Format Cells

General"0000" ?
--
David Biddulph

"PR" wrote in message
...
I am trying to get a way of fformatting a cell with 4 trailing zeros... at
the moment I can opnly seem to get leading zeros...

I woul like to see the following:

12 becoming 120000 not 000012...

Regaards

All times are GMT +1. The time now is 09:30 AM.