Thread: How to add a zero infront of a number
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
  
Posts: 284
Default How to add a zero infront of a number
CYNTHIA

Glad you got it sorted out, thanks for the feed back!!

Mike Rogers

"CYNTHIA" wrote:

this is fast and works

"Mike Rogers" wrote:

CYNTHIA

Place an apostrophe first then your number (the apostrophe will not show on
the sheet but will be seen in the formula bar), or formate the cell as text.

Mike Rogers

"CYNTHIA" wrote:

How do I add a zero infront of a number.

For example I want the number to be read like this:

012

But i type in excel it shows up as 12.


Reply With QuoteReply With Quote