Home » Category » Microsoft Excel

Microsoft Excel: Zeros

205| Thu, 22 May 2008 21:04:00 GMT| anonymous| Comments (2)
I need to place a Zero in front of a number, but when i press enter, it goes
away, how can i keep it there'?

Keywords & Tags: zeros, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495013/
 
«« Prev - Next »» 2 helpful answers below.
Precede your number with a single quote...

'055

...or format your cell as 'Text'.

Hope this helps!

In article <B65FF2D6-B845-4D01-8004-33F6515FB11D...microsoft.com>,
Dena B <DenaB...discussions.microsoft.com> wrote:

> I need to place a Zero in front of a number, but when i press enter, it goes
> away, how can i keep it there'?

domenic | Thu, 22 May 2008 21:05:00 GMT |

Or if you truly need a "real" number,
Custom format to the number of digits you'll need.

00000
or
0000
or whatever.
--
Regards,

RD
----
Please keep all correspondence within the NewsGroup, so all may benefit !
----
"Domenic" <domenic22...sympatico.ca> wrote in message
news:domenic22-21C136.11065429082005...msnews.microsoft.com...
> Precede your number with a single quote...
> '055
> ...or format your cell as 'Text'.
> Hope this helps!
> In article <B65FF2D6-B845-4D01-8004-33F6515FB11D...microsoft.com>,
> Dena B <DenaB...discussions.microsoft.com> wrote:
> > I need to place a Zero in front of a number, but when i press enter, it
goes
> > away, how can i keep it there'?

ragdyer | Thu, 22 May 2008 21:06:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories