Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how i use formula when i put the comma myself
When i type the figure like 1234567 and used comma in tool bar then figure
look like 1,234,567.00 but if we want to figure look like 12,34,567 then how we do it and if we write the figure likse 12,34,567 form Key Board and put the formula then formula does'nt work then please help me how i write the figure like 12,34,567 and put the formula. |
#2
|
|||
|
|||
Missi,
If you can use something other than a comma, like a hyphen, then you can get a result like 12-34-567 By using Format - Cells - Custom: ##-##-### -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Missi" wrote in message ... When i type the figure like 1234567 and used comma in tool bar then figure look like 1,234,567.00 but if we want to figure look like 12,34,567 then how we do it and if we write the figure likse 12,34,567 form Key Board and put the formula then formula does'nt work then please help me how i write the figure like 12,34,567 and put the formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |