LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 86
Default How to add a zero infront of a number

Thanks for your help.

"RobN" wrote:

But if you want it to still behave as numeric, you could apply the custom
format of "0"0 to those cells.

Rob

"CYNTHIA" wrote in message
...
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.







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What does the $ infront of a cell indicate in a calculation mean? kb556617sm Excel Discussion (Misc queries) 1 September 10th 07 06:42 PM
Add a number infront of a number Nikki Excel Discussion (Misc queries) 5 February 28th 07 01:51 AM
automatic multiple insertion of 0 infront of a tel number? Collet Makgojane Excel Discussion (Misc queries) 2 January 31st 07 08:04 AM
How do I format a cell so there can be a zero infront of a # (04) mcquade Excel Discussion (Misc queries) 2 March 29th 06 09:50 PM
how to have numbers add/sub without putting = infront captdewey New Users to Excel 4 August 3rd 05 10:09 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"