Format Number
Hi,
Select the cells and choose Format, Cells, Custom, and enter the following custom format: General"00" -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: I am trying to figure out how to format $100.00 as 10000. When I format it I get 100 or 100.00. Thank you |
Format Number
What if the $100.00 was only a badly chosen example and other money amounts
like $123.45 could occur? -- Rick (MVP - Excel) "Shane Devenshire" wrote in message ... Hi, Select the cells and choose Format, Cells, Custom, and enter the following custom format: General"00" -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: I am trying to figure out how to format $100.00 as 10000. When I format it I get 100 or 100.00. Thank you |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com