Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change number format
hi
i want to change the number format in excel .usually when i input number like 123456789, i am getting the number as 123,456,789.00 . but i need the number to be in Indian standard like 12,34,56,789.00. please find the solution and reply me... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change number format
[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gaj" wrote in message ... hi i want to change the number format in excel .usually when i input number like 123456789, i am getting the number as 123,456,789.00 . but i need the number to be in Indian standard like 12,34,56,789.00. please find the solution and reply me... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Time format to number while keeping value | Excel Worksheet Functions | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
Global fix for scientific number format? | Excel Discussion (Misc queries) | |||
how to change the h:mm format to number? | Excel Worksheet Functions |