BSAT Student

Posts: n/a

Format percentage as a decimal

Thanks so much for the help. Works perfectly!

"Niek Otten" wrote:

FormatCellsNumberCustom
In the Type box, enter

..###############

--
Kind regards,

Niek Otten

"BSAT Student" <BSAT wrote in message
...
How would I format a percentage as a decimal without the leading zero. For
example:
0.532 as .532 - no zero

Any help appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Why does my format keep changing in the cell?	Denise	Excel Discussion (Misc queries)	0	August 30th 05 04:23 PM
Convert decimal degree (lattitude/longitude) into Degree,	Tim Ashcom	Excel Discussion (Misc queries)	5	August 17th 05 04:53 PM
Convert [h]:mm sum total format to number format	Guy	Excel Worksheet Functions	1	August 5th 05 05:56 AM
protecting format	Esmerelda	Excel Discussion (Misc queries)	1	February 25th 05 12:53 PM
Change decimal format of cells depending on conditions?	Cornelius	Excel Worksheet Functions	1	February 25th 05 12:57 AM

All times are GMT +1. The time now is 05:55 PM.

About Us

"It's about Microsoft Excel"