ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   question about numbers (https://www.excelbanter.com/setting-up-configuration-excel/115322-question-about-numbers.html)

shpiro

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




Paul B

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






shpiro

question about numbers
 
works, thanks




All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com