#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default question about numbers

how to setup sheet (excel 2003) to show zero in front of the rest of number
like 001,25 not 1,25



  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 709
Default question about numbers

shpiro, you can format the cells as text before you put the number in,
format, cells, number, text or put an apostrophe ' in front of the number,
it want show in the cell

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"shpiro" wrote in message
...
how to setup sheet (excel 2003) to show zero in front of the rest of

number
like 001,25 not 1,25





  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default question about numbers

works, thanks


Reply
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
Is this possible ??? DB Excel Discussion (Misc queries) 12 August 26th 06 12:19 AM
Numbers stored as text causes problem with VLOOKUP bpeltzer Excel Worksheet Functions 0 February 4th 06 08:07 PM
Easy question? Page numbers ATC Excel Discussion (Misc queries) 1 February 1st 06 04:27 AM
formulas to numbers Steve New Users to Excel 2 September 16th 05 12:07 AM
Count comma separated numbers, numbers in a range with dash, not t Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM


All times are GMT +1. The time now is 11:59 PM.

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

About Us

"It's about Microsoft Excel"