Thread
:
Format a cell to keep leading zeros.
View Single Post
#
4
Gord Dibben
Posts: n/a
David
Excel has no FORMAT Function except in VBA.
I think you may have meant =TEXT(A4,"0000000")
This would leave the numbers as text and could not be readily used for
calculations.
Gord Dibben Excel MVP
On Wed, 5 Jan 2005 09:13:06 -0800, David Jessop <David
wrote:
Another approach is to use =FORMAT(A4,"0000000") which creates a string with
the correct number of leading zeros, rather than just displaying it in this
way.
Regards,
David Jessop
"Chip Pearson" wrote:
Use a custom number format of 000000 or as many zero as you need.
"Shadyhosta" wrote in
message
...
I often deal with account numbers with leading zeros. When I
place them in a
cell Excel automatically deletes the leading zeros. Is there a
way to format
the cell to hold the zeros?
Reply With Quote